Moving a database

From: Ewan Leith <ejl(at)man(dot)fwltech(dot)com>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Moving a database
Date: 2001-12-10 14:52:05
Message-ID: 1012BD903945D411915500105A48FF57126EBB@nt.man.fwltech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-12-10 15:40:58 Re: Moving a database
Previous Message darthxiong 2001-12-10 08:39:29 table name as parameter in pl/psql