pg_dump and restore

From: John Herreshoff <jkherr(at)centurytel(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: pg_dump and restore
Date: 2002-02-16 15:54:15
Message-ID: 200202161558.g1GFw9g07744@mail3.centurytel.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi.

1. pg_dump works just great, but pg_restore does not. I can reload the
database with pg_restore; I need to use psql. Anyone know what's up?

2. When I restored the database, psql complained that it could not find
users and groups. I would assume that I need to use some switch with pg_dump
in order to save the users and groups. Again, anyone know how to solve this
problem?

TIA.

John.

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2002-02-16 16:38:05 Psql & Readline
Previous Message Tom Lane 2002-02-16 04:38:30 Re: join question