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

2013-08-02 Thread tot-to
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 copied it to another machine, manually created t

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

2013-08-02 Thread tot-to
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 cre