From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
Cc: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>, Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>, PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: tablespace and sequences? |
Date: | 2004-08-19 01:39:27 |
Message-ID: | 200408190139.i7J1dRQ01642@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin pgsql-hackers pgsql-hackers-win32 |
Christopher Kings-Lynne wrote:
> > It is a little bit different because a schema, a table or a function are
> > database application issues and are normally addressed by pg_dump and
> > pg_restore, although tablespaces are more an administration issue wrt disk
> > layout and the like, which are likely to be different from one machine to
> > another (compare with I obviously want the same schema/table/function for
> > my application). So the notion of dump/restore of a tablespace need
> > some careful thinking.
> >
> > But maybe I'm just stupid to dream that I could restore or transfer my
> > data even if I used a tablespace somewhere? ;-)
>
> OK, perhaps. It it not easy to implement however, since the tablespace
> clause on indexes comes from the pg_get_indexdef() function and isn't
> added by pg_dump.
>
> Bruce - pg_dump TODO for --no-tablespace or something?
Uh, TODO already has:
* Allow database recovery where tablespaces can't be created
When a pg_dump is restored, all tablespaces will attempt to be created
in their original locations. If this fails, the user must be able to
adjust the restore process.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2004-08-19 04:18:32 | Re: tablespace and sequences? |
Previous Message | Christopher Kings-Lynne | 2004-08-19 01:31:04 | Re: tablespace and sequences? |
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2004-08-19 01:40:23 | Re: Tablespace and cpu costs |
Previous Message | Christopher Kings-Lynne | 2004-08-19 01:38:16 | Re: PGPASSWORD and client tools |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-08-19 02:35:01 | Re: REPOST: InitDB Failure on install |
Previous Message | Christopher Kings-Lynne | 2004-08-19 01:31:04 | Re: tablespace and sequences? |