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
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 |