pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / 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