Hello,
I've just come across this in an output from a cron backup script:
/etc/cron.hourly/gtwm_backup_databases.sh:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: could not open relation with OID 572838
pg_dump: The command was: SELECT pg_catalog.pg_get_viewdef('572838'::pg_catalog.oid) AS viewdef
The complete script is
#!/bin/bash
nice /usr/bin/pg_dump -U postgres -f /var/local/backup/agilebaseschema_`/bin/date +%H`.sql agilebaseschema
nice /usr/bin/pg_dump -U postgres --exclude-table=dbint_log_* -f /var/local/backup/agilebasedata_`/bin/date +%H`.sql agilebasedata
Running the script again manually, it works with no errors and I haven't noticed the error before. Unfortunately I recently deleted my archive of cron results so I can't do an exhaustive check and I can't see anything in the postgres log either but it's the first time I've noticed it since I can remember.
A web search shows other people have come across this before now and again though I can't see any resolutions. I'm running postgres v8.4.1.
Running that SELECT statement manually on both databases returns
agilebasedata=# SELECT pg_catalog.pg_get_viewdef('572838'::pg_catalog.oid) AS viewdef;
viewdef
------------
Not a view
(1 row)
Views are regularly altered, dropped and created in the agilebasedata database, 15 times today to date, which have all succeeded without error.
Any help on what could cause that error?
Regards
Oliver Kohll
oliver@xxxxxxxxxxxxxxx / 0845 456 1810 / 07814 828608
www.agilebase.co.uk - software
www.gtwm.co.uk - company
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
