Moving a database - Mailing list pgsql-admin

From Ewan Leith
Subject Moving a database
Date
Msg-id 1012BD903945D411915500105A48FF57126EBB@nt.man.fwltech.com
Whole thread Raw
Responses Re: Moving a database  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "darthxiong@libero.it"
Date:
Subject: table name as parameter in pl/psql
Next
From: Tom Lane
Date:
Subject: Re: Moving a database