How to restore some DBs to a new server?

From: Bob Futrelle <bob(dot)futrelle(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: How to restore some DBs to a new server?
Date: 2013-09-13 21:03:07
Message-ID: CAOsWdXrvVFAtkUMPMXOEU1=g=i4MTA1ZsKC7eJCCbQB_gp7wRg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Running on my MacBook Pro, pgAdmin3 tells me I have four servers in "Server
Groups",
all local, no network involved.

I have dumped two of my DBs from a current server using pg_dump.
Then in pgAdmin3 I created another server, let's call it "New".

I would like to look at these earlier DBs while not disturbing my current
DBs.
So I would like to reload both the dumps into "New",
but I can't find the magic invocation that does this,
in pgAdmin3 or using pg_restore or directly in psql.

I realize that this isn't rocket science, so I'll blush a bit when the
simplicity of it is revealed.

- Bob

Responses

Browse pgsql-general by date

  From Date Subject
Next Message rob stone 2013-09-13 21:08:43 Re: Small PosgreSQL locking function request - with bounty
Previous Message Stephen Frost 2013-09-13 20:29:47 Re: Using LDAP for PostgreSQL permissions/authentication