About pgaccess tables

From: * Tong * <tong(at)none(dot)hub(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: About pgaccess tables
Date: 2002-11-20 21:26:00
Message-ID: 3DDBFDE8.10006@none
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm looking the appropriate ways to handle the pgaccess tables.

My problem is, I use 'pg_dump -C $db' to backup my database. But the
pgaccess tables are backuped also. I want a clean backup of my database
only, so I've been dropping the pgaccess tables before doing the backup.

This is a bit troublesome but I get what I want. But for
pgaccess-0.98.8b2, the trick seems no longer applicable any more. After
I dropped all the pgaccess tables, I get the following error when trying
to start pgaccess again:

Error in startup script: ERROR: Relation "pga_scripts" does not exist

while executing
"pg_select pgsql4 {SELECT *
FROM Pga_scripts
WHERE scriptname ~* '^autoexec$'} recd {
eval $recd(scriptsource)
..."
("uplevel" body line 1)
[...]

So, what is the best way to keep a clean backup of my-database-only
while keep pgaccess happy?

Thanks!

tong

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2002-11-20 21:33:15 Re: Closing inactive connections OR user connections limits
Previous Message Neil Conway 2002-11-20 21:15:57 Re: Closing inactive connections OR user connections limits