Re: [NOVICE] Creating a new server

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: "Carlson, James \(Jim\)" <jcarlson(at)rti(dot)org>, pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Creating a new server
Date: 2006-11-13 22:08:29
Message-ID: 20061113220829.20296.qmail@web31801.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

> Okay, I tried
> >pg_dumpall > sync-up.db
> Connected to template1...
> Psql: FATAL 1: user "jcarlson" does not exist
>
>
> I tried to use the -U option without success. How do I add a user ore
> determine a user that will work for pg_dumpall

I see, you are actually having a problem with pg_dumpall terminating unsuccessfully. You might
want to forward this concern over to the pg_general mailing list.

pgsql-general(at)postgresql(dot)org

There are more users on that list that will able to help you get around this problem. I am
guessing that you may a record somewhere that may have been corrupted. It can be easy to correct
with some help from more advanced Postgresql users.

The help these users, turn on statement logging in your postgresql.conf and restart your server.
email the list showing the issued command, error messages that result, and any logs snippets that
were generated up to the failure.

But just be prepared to for the first recommendation to move to postgresql 8.1 or eventually 8.2.
>From what I understand versions 7.2 maybe 7.3 have known bugs that can/will eat your data.

Regards,

Richard Broersma Jr.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2006-11-13 22:23:36 Re: Speed of postgres compared to ms sql, is this
Previous Message Carlson, James (Jim) 2006-11-13 21:59:13 Re: Creating a new server

Browse pgsql-novice by date

  From Date Subject
Next Message Richard Broersma Jr 2006-11-13 22:11:22 Re: methodology tuning
Previous Message Carlson, James (Jim) 2006-11-13 21:59:13 Re: Creating a new server