Matt Beauregard <[EMAIL PROTECTED]> writes:
>> Since these are only views, the datafiles underlying them would be empty
>> anyway --- so you can recreate the datafiles just by doing
>> "touch $PGDATA/base/template1/pg_user" etc.
> I've touched pg_user and pg_group but the db still won't find them
On Wed, Nov 08, 2000 at 10:03:05PM -0500, Tom Lane wrote:
> Matt Beauregard <[EMAIL PROTECTED]> writes:
> NOTICE: mdopen: couldn't open pg_user: No such file or directory
> >>
> >> This is strange in itself. There should be an (empty) file named
> >> pg_user in your $PGDATA/base/template1
Matt Beauregard <[EMAIL PROTECTED]> writes:
NOTICE: mdopen: couldn't open pg_user: No such file or directory
>>
>> This is strange in itself. There should be an (empty) file named
>> pg_user in your $PGDATA/base/template1 directory --- is there?
>> What about pg_views?
> Neither are there
On Wed, Nov 08, 2000 at 08:40:08PM -0500, Tom Lane wrote:
> Matt Beauregard <[EMAIL PROTECTED]> writes:
> >> The plot thickens ... what did you say the error message was
> > exactly?
>
> > !759 marauder@bofh:~$ pg_dump -h tweedledee ds
> > getTypes(): SELECT failed. Explanation from backend: 'ER
Matt Beauregard <[EMAIL PROTECTED]> writes:
> I get the following error trying to make my backups:
> !2188 marauder@bofh:~$ pg_dump -h tweedledee -D ds >ds_1108.sql
> getTypes(): SELECT failed. Explanation from backend: 'ERROR:
> Relation 'pg_user' does not exist
Hmm, did you do something silly
I get the following error trying to make my backups:
!2188 marauder@bofh:~$ pg_dump -h tweedledee -D ds >ds_1108.sql
getTypes(): SELECT failed. Explanation from backend: 'ERROR:
Relation 'pg_user' does not exist
How can I fix the error without losing any of our data, or at least
get my dumps wo
