| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | "Leonardo M(dot) Ramé" <l(dot)rame(at)griensu(dot)com>, PostgreSql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_dump/pg_restore issues |
| Date: | 2014-02-19 18:41:51 |
| Message-ID: | 5304FAEF.8000604@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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:
>>
>> view.dump
>> basic.backup
>
> That makes sense, I'll try it.
You will still hit the sequence issue you mentioned previously, unless
you include it as one of the -t options. If you are using the -Fc option
already I would do as bricklen suggested and just use the TOC list. Then
you could include the sequence in the restore.
>
> Regards,
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Cardno | 2014-02-19 19:01:31 | Query |
| Previous Message | Leonardo M. Ramé | 2014-02-19 18:32:53 | Re: pg_dump/pg_restore issues |