Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7LEDAP16538 for ; Tue, 21 Aug 2001 10:13:10 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f7LECiY29345; Tue, 21 Aug 2001 10:12:45 -0400 (EDT) To: Carolyn Lu Wong cc: pgsql-sql@postgresql.org Subject: Re: database location question In-reply-to: <3B81EF6B.DAE19436@greatpacific.com.au> References: <3B81EF6B.DAE19436@greatpacific.com.au> Comments: In-reply-to Carolyn Lu Wong message dated "Tue, 21 Aug 2001 15:19:39 +1000" Date: Tue, 21 Aug 2001 10:12:44 -0400 Message-ID: <29342.998403164@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200108/266 X-Sequence-Number: 4513 Carolyn Lu Wong 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