Re: [GENERAL] pg_dump/pg_restore issues

On 02/19/2014 10:32 AM, Leonardo M. Ramé wrote: On 2014-02-19 10:23:58 -0800, Adrian Klaver wrote: Another alternative would be to add another backup: pg_dump -s -t table1 -t table2 -f view.dump This will dump the table definitions only which is all you need. And then in order restore: vie

Re: [GENERAL] pg_dump/pg_restore issues

On 2014-02-19 10:23:58 -0800, Adrian Klaver wrote: > On 02/19/2014 10:08 AM, bricklen wrote: > > > >On Wed, Feb 19, 2014 at 9:57 AM, Leonardo M. Ramé > >mailto:l.r...@griensu.com>> wrote: > > > >Hi, I'm backing up a big database using the --exclude-table option for > >two tables, say table1

Re: [GENERAL] pg_dump/pg_restore issues

On 02/19/2014 10:08 AM, bricklen wrote: On Wed, Feb 19, 2014 at 9:57 AM, Leonardo M. Ramé > wrote: Hi, I'm backing up a big database using the --exclude-table option for two tables, say table1 and table2. Then another backup of only those tables, so, the

Re: [GENERAL] pg_dump/pg_restore issues

On 2014-02-19 10:08:19 -0800, bricklen wrote: > On Wed, Feb 19, 2014 at 9:57 AM, Leonardo M. Ramé wrote: > > > Hi, I'm backing up a big database using the --exclude-table option for > > two tables, say table1 and table2. Then another backup of only those > > tables, so, the final result are three

Re: [GENERAL] pg_dump/pg_restore issues

On Wed, Feb 19, 2014 at 9:57 AM, Leonardo M. Ramé wrote: > Hi, I'm backing up a big database using the --exclude-table option for > two tables, say table1 and table2. Then another backup of only those > tables, so, the final result are three backup files. > > basic.backup > table1.backup > table2.

[GENERAL] pg_dump/pg_restore issues

Hi, I'm backing up a big database using the --exclude-table option for two tables, say table1 and table2. Then another backup of only those tables, so, the final result are three backup files. basic.backup table1.backup table2.backup The problem I'm facing is at the restore moment is that basic.b