pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
database location question
2+ messages / 2 participants
[nested] [flat]

* database location question
@ 2001-08-21 05:19  Carolyn Lu Wong <carolyn@greatpacific.com.au>
  0 siblings, 1 reply; 2+ messages in thread

From: Carolyn Lu Wong @ 2001-08-21 05:19 UTC (permalink / raw)
  To: pgsql-sql

I'm using V6.5.3.

Is there a way to move the database to another directory location
instead in /var/lib/pgsql? As this is on the root file system on the
server and it's using to much spaces.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: database location question
@ 2001-08-21 14:12  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Carolyn Lu Wong <carolyn@greatpacific.com.au>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2001-08-21 14:12 UTC (permalink / raw)
  To: Carolyn Lu Wong <carolyn@greatpacific.com.au>; +Cc: pgsql-sql

Carolyn Lu Wong <carolyn@greatpacific.com.au> writes:
> I'm using V6.5.3.

You really oughta update ;-)

> Is there a way to move the database to another directory location
> instead in /var/lib/pgsql?

Sure, just shut down the postmaster, physically move the entire data tree
(use 'cp -p -r' or 'tar' or some such), put a symlink to the new place
at /var/lib/pgsql/data, and away you go.  Or forget the symlink and
instead tell the postmaster where the data tree is with a -D switch.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-08-21 14:12 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-08-21 05:19 database location question Carolyn Lu Wong <carolyn@greatpacific.com.au>
2001-08-21 14:12 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox