moving a single database

From: Tom Allison <tallison(at)tacocat(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: moving a single database
Date: 2006-11-18 23:50:15
Message-ID: 455F9C37.3000209@tacocat.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I want to move just one database from server A to server B.

The files under /var/lib/postgresql/8.1/ are not exactly jumping out and telling
me which files belong to which database.

So, how do you move a database (not the entire postgresql installation)?

Considering the existence of things like triggers and sequences -- will a simple
dump/restore be sufficient?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Broersma Jr 2006-11-19 03:23:25 Re: moving a single database
Previous Message Tom Lane 2006-11-18 18:23:07 Re: postgres authentication question