[GENERAL] pg_restore issue

2014-02-12 Thread Leonardo M . Ramé
Hi, I'm trying to restore a database dump using pg_restore with the following parameters: pg_restore -h 127.0.0.1 -U _postgresql \ -c -d postgres --exit-on-error \ my_dump.backup Note I used \ to wrap the command, but the real one does not have those. pg_restore: [archiver (db)] Error while

Re: [GENERAL] pg_restore issue

2014-02-12 Thread Adrian Klaver
On 02/12/2014 09:41 AM, Leonardo M. Ramé wrote: Hi, I'm trying to restore a database dump using pg_restore with the following parameters: pg_restore -h 127.0.0.1 -U _postgresql \ -c -d postgres --exit-on-error \ my_dump.backup Note I used \ to wrap the command, but the real one does not

Re: [GENERAL] pg_restore issue

2014-02-12 Thread Tom Lane
Leonardo =?iso-8859-1?Q?M=2E_Ram=E9?= l.r...@griensu.com writes: Hi, I'm trying to restore a database dump using pg_restore with the following parameters: pg_restore -h 127.0.0.1 -U _postgresql \ -c -d postgres --exit-on-error \ my_dump.backup Note I used \ to wrap the command, but the

Re: [GENERAL] pg_restore issue

2014-02-12 Thread Leonardo M . Ramé
On 2014-02-12 09:51:10 -0800, Adrian Klaver wrote: On 02/12/2014 09:41 AM, Leonardo M. Ramé wrote: Hi, I'm trying to restore a database dump using pg_restore with the following parameters: pg_restore -h 127.0.0.1 -U _postgresql \ -c -d postgres --exit-on-error \ my_dump.backup

Re: [GENERAL] pg_restore issue

2014-02-12 Thread Leonardo M . Ramé
On 2014-02-12 13:30:52 -0500, Tom Lane wrote: Leonardo =?iso-8859-1?Q?M=2E_Ram=E9?= l.r...@griensu.com writes: Hi, I'm trying to restore a database dump using pg_restore with the following parameters: pg_restore -h 127.0.0.1 -U _postgresql \ -c -d postgres --exit-on-error \

Re: [GENERAL] pg_restore issue

2014-02-12 Thread Tom Lane
Leonardo =?iso-8859-1?Q?M=2E_Ram=E9?= l.r...@griensu.com writes: On 2014-02-12 13:30:52 -0500, Tom Lane wrote: The -c switch causes pg_restore to try to DROP every object it's about to restore. If you're restoring into an empty database then this is useless, and in fact will not work if

Re: [GENERAL] pg_restore issue

2014-02-12 Thread Leonardo M . Ramé
On 2014-02-12 14:04:41 -0500, Tom Lane wrote: Leonardo =?iso-8859-1?Q?M=2E_Ram=E9?= l.r...@griensu.com writes: On 2014-02-12 13:30:52 -0500, Tom Lane wrote: The -c switch causes pg_restore to try to DROP every object it's about to restore. If you're restoring into an empty database then

Re: [GENERAL] pg_restore issue

2014-02-12 Thread Jerry Sievers
Leonardo M. Ramé l.r...@griensu.com writes: On 2014-02-12 13:30:52 -0500, Tom Lane wrote: Leonardo =?iso-8859-1?Q?M=2E_Ram=E9?= l.r...@griensu.com writes: Hi, I'm trying to restore a database dump using pg_restore with the following parameters: pg_restore -h 127.0.0.1 -U _postgresql \