Re: [GENERAL] pg_restore issue

2014-02-12 Thread Jerry Sievers
Leonardo M. Ramé writes: > On 2014-02-12 13:30:52 -0500, Tom Lane wrote: > >> Leonardo =?iso-8859-1?Q?M=2E_Ram=E9?= 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

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?= 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 usel

Re: [GENERAL] pg_restore issue

2014-02-12 Thread Tom Lane
Leonardo =?iso-8859-1?Q?M=2E_Ram=E9?= 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 you're also using

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?= 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.backu

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.b

Re: [GENERAL] pg_restore issue

2014-02-12 Thread Tom Lane
Leonardo =?iso-8859-1?Q?M=2E_Ram=E9?= 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 real one d

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

[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 whil