Tag Info

New answers tagged

0

Yes this type of error is faced by most user who are new to pgadmin.I have found below solution and it worked for me hope this will work for you as well. I used below commands on my Ubuntu 12.04 LTS recently. sudo -u postgres psql This will ask for your system password and then you will get the PostgreSQL prompt. and then in psql type below command to ...


0

Try to recover the database using force_recovery option 4 or higher but this can permanently corrupt the database as options higher than this will try to commit transactions which wasn't completed. If the recovery worked, and you wont like to recover each database by hand then start MySQL by skipping grant tables and dump all the databases. Install a fresh ...


0

It depends on the VM software you are using. In case of VirtualBox you have to check what type of connection you set (NAT, bridge, etc); if using NAT you need to enable a port-forward to the listener port: e.g. TCP 21521 on host, TCP 1521 on VM). Also check if iptables firewall is enabled on your VM.


0

I solve it by add some extra command in terminal, like this : isql -v mydb and the result : +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | ...


0

COPY doesn't understand the shell-script shorthand ~ for "my home directory". You must specify the path explicitly, e.g. COPY nh FROM '/home/MYUSERNAME/Dropbox/0ptimus-Jaspin/VoterMapping--NH--03-17-2014-HEADERS.tab'; at which point you'll probably get a "permission denied" error, because COPY runs as the postgresql server user, which can't normally read ...


1

Neo4j is a database that sounds a fit for your needs. It is graph based database, there are many drivers for it in many languages and it is built in Java. In this database, you would specify the relationships within each node, rather than creating tables for joins, like in mySQL.


0

This year I have the opportunity to work with IBM Optim that claims to do what is asked for. Is not free, but it works fine.


0

you can use rman active duplicate database RMAN DUPLICATE TARGET DATABASE TO xxxx FROM ACTIVE DATABASE; but you have two big disadvantages: 1. Negative performance impact on the source database. This impact applies to the whole duplication time. 2. High network traffic on the connection between the source and target databases.


2

You'll want to create a directory without the t (sticky) permissions bit set, and have PostgreSQL copy the file into there. You should also make the directory setgid (g+s), as that makes the group inherited from the directory, not the creating process; see setgid directories. You could put this directory in /tmp but personally I'd put it some neutral ...



Top 50 recent answers are included