Received: from monsoon.mail.pipex.net (monsoon.mail.pipex.net [158.43.128.69]) by postgresql.org (8.11.3/8.11.4) with SMTP id fBAEpjm46745 for ; Mon, 10 Dec 2001 09:51:45 -0500 (EST) (envelope-from ejl@man.fwltech.com) Received: (qmail 13506 invoked from network); 10 Dec 2001 14:51:48 -0000 Received: from useri147.dsl.pipex.com (HELO man.fwltech.com) (62.188.56.147) by smtp-1.dial.pipex.com with SMTP; 10 Dec 2001 14:51:48 -0000 Received: from fwmapc100.man.fwltech.com (fwmapc100 [1.1.4.100]) by man.fwltech.com (AIX4.3/8.9.3/8.7) with ESMTP id OAA194866 for ; Mon, 10 Dec 2001 14:48:28 GMT Received: by nt.man.fwltech.com with Internet Mail Service (5.5.2650.21) id ; Mon, 10 Dec 2001 14:52:05 -0000 Message-ID: <1012BD903945D411915500105A48FF57126EBB@nt.man.fwltech.com> From: Ewan Leith To: "'pgsql-admin@postgresql.org'" Subject: Moving a database Date: Mon, 10 Dec 2001 14:52:05 -0000 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200112/59 X-Sequence-Number: 2783 Hi all, we recently upgraded from 6.53 to 7.1.2, and at the same time tried to move the database to a new filesystem. However, while the upgrade was 100% successful using pg_dumpall, we see that postgres is still reading some files from the old file system (though only updating the new files). An example is pg_shadow which is read on both file systems whenever someone seems to authenticate, but only updated on the new file system. Does anyone have any ideas? Is it possible to move the location of Postgres in this manner? Thanks, Ewan