From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | pmoscatt(at)bigpond(dot)net(dot)au |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Re: CREATEDB Where ?? |
Date: | 2001-08-20 21:04:06 |
Message-ID: | 10231.998341446@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Peter Moscatt <pmoscatt(at)bigpond(dot)net(dot)au> writes:
> Right..... If I was developing an application, say with Python and I
> needed to transport my created database and make it part of an installation
> process (create a tar ball with all needed components), do I just include
> the /usr/local/pgsql/data directory as part of my dist ??
No --- a tar dump of your directory will be quite useless to anyone else
on a different platform, and even those on the same platform would
likely not want to blow away their databases and replace 'em with yours.
Instead, use pg_dump to create an SQL script that can be loaded into an
existing database installation.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-08-20 21:21:21 | Re: [PATCHES] LIKE indexing |
Previous Message | Bruce Momjian | 2001-08-20 19:33:49 | Re: CREATEDB Where ?? |