From: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
---|---|
To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>, PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: tablespace and sequences? |
Date: | 2004-08-18 08:24:37 |
Message-ID: | Pine.LNX.4.58.0408181012110.30419@sablons.cri.ensmp.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin pgsql-hackers pgsql-hackers-win32 |
> > I'm not thinking about pg_dumpall but pg_dump/pg_restore.
>
> Tablespaces are dumped by pg_dumpall, not pg_dump.
If so, indeed it would be a non-issue. However,
shell> pg_dump coelho | grep TABLESPACE
CREATE SCHEMA test AUTHORIZATION coelho TABLESPACE test;
"TABLESPACE" appears in a basic pg_dump SQL output. If the test tablespace
does not exist, the command will fail, and so my whole restoration.
Thus I still stick to my opinion;-)
Have a nice day,
--
Fabien Coelho - coelho(at)cri(dot)ensmp(dot)fr
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2004-08-18 08:39:40 | Re: tablespace and sequences? |
Previous Message | Christopher Kings-Lynne | 2004-08-18 07:45:41 | Re: tablespace and sequences? |
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2004-08-18 08:39:40 | Re: tablespace and sequences? |
Previous Message | Alvaro Herrera | 2004-08-18 07:49:59 | Re: [HACKERS] SRPM for 8.0.0 beta? |
From | Date | Subject | |
---|---|---|---|
Next Message | Eric Rosenquist | 2004-08-18 08:37:31 | Re: psql reading from stdin |
Previous Message | Christopher Kings-Lynne | 2004-08-18 07:45:41 | Re: tablespace and sequences? |