| From: | Anne Wainwright <anotheranne(at)fables(dot)co(dot)za> |
|---|---|
| To: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | cannot do backup - locked? |
| Date: | 2013-09-16 00:03:50 |
| Message-ID: | 20130916000350.GA8848@fables.co.za |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi
I have previously done my backups in these ways, but now we get 'locked'
messages.
pandora(at)jason:~$ pg_dump -C -f fables_back_20130916.sql Fables
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: permission denied for
relation books
pg_dump: The command was: LOCK TABLE public.books IN ACCESS SHARE MODE
pandora(at)jason:~$ pg_dump -a -f fables_data_20130916.sql Fables
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: permission denied for
relation books
pg_dump: The command was: LOCK TABLE public.books IN ACCESS SHARE MODE
(this second command used a -d flag, but this looks like it has been
changed to --inserts ??
whatever, what is happening here? I clearly have files created by these
commands, but dated a long time back, in the postgres user account.
Anne
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lonni J Friedman | 2013-09-16 00:28:36 | Re: cannot do backup - locked? |
| Previous Message | David Johnston | 2013-09-15 14:05:57 | Re: sorting of a price field |