Re: [GENERAL] Dump file created with pg_dump cannot be restored with psql

2013-08-09 Thread gilroy
For that matter, for the first time we tried enforcing some of the "rules" of CFs this time, and I'd like to hear if people think that helped. I think he merit of "fast promote" is - allowing quick connection by skipping checkpoint and its demerit is - taking little bit longer when crash-recove

Re: [GENERAL] Dump file created with pg_dump cannot be restored with psql

2013-08-02 Thread tot-to
Oh, sorry. I mixed up dumps... I am migrating from mysql and by mistake I tried to apply dump from "mysqldump --compat=postgresql" that was named very similar to dump of finally converted database produced by pg_dump (for the purpose of copy from test to main server). Bash comletitions and then

Re: [GENERAL] Dump file created with pg_dump cannot be restored with psql

2013-08-02 Thread Adrian Klaver
On 08/02/2013 05:03 PM, tot-to wrote: I have two installation of postgresql-server-9.2.4 on Gentoo. I try to just copy database from one to another. According to the documentation http://www.postgresql.org/docs/9.2/static/backup-dump.html I created dump file: psql -U > dumpfile.sql I would