Re: pgdump

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: Andreas Tille <tillea(at)rki(dot)de>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: pgdump
Date: 2000-09-19 17:04:15
Message-ID: 20000919100415.A1714@feivel.credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Sep 19, 2000 at 09:15:32AM +0200, Andreas Tille wrote:
> if I do a database dump via pg_dump also PostgreSQL internal tables
> named pga_* are stored in the dump. However if I drop a database and

pga_* are not really internal tables. The internal tables are named pg_*.
pga_* are tables created by pgaccess.

> create it via "create database <name>" those tables are created
> automatically. Restoring the old content of the database using

What version are you using? On my 7.0.2 (actual Debian package, so I guess
you are using the same) they are definitely not created autiomatically.

Michael
--
Michael Meskes
Michael(at)Fam-Meskes(dot)De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!

In response to

  • pgdump at 2000-09-19 07:15:32 from Andreas Tille

Responses

  • Re: pgdump at 2000-09-19 08:17:39 from Andreas Tille
  • Re: pgdump at 2000-09-19 15:49:10 from Ross J. Reedstrom

Browse pgsql-general by date

  From Date Subject
Next Message leonbloy 2000-09-19 17:26:48 Re: nasty problem with redhat 6.2 + pg 7.02
Previous Message Ross J. Reedstrom 2000-09-19 16:59:58 Re: nasty problem with redhat 6.2 + pg 7.02