From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: George Clark <grclark78@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: default console user authentication?
Date: Tue, 12 Oct 2010 15:08:11 -0500
Message-ID: <4CB479DB02000025000368A9@gw.wicourts.gov> (raw)
In-Reply-To: <AANLkTimX4BNmUm7KJ72FUBu+FgcKDxZdMcK4FkTfOmwA@mail.gmail.com>
References: <AANLkTimX4BNmUm7KJ72FUBu+FgcKDxZdMcK4FkTfOmwA@mail.gmail.com>
George Clark <grclark78@gmail.com> wrote:
> I'm trying to do a pg_dump to backup a database that is part of
> our phone system. The original installers (phone people) seem to
> know nothing about the superuser account, or the db admin account,
> and the pg_dump needs a password authentication.
>
> The pg_dump command is asking for the password for user
> "Administrator." I'm logged into the server (a Windows Server) as
> the Admin user, but it is NOT THAT password it wants, because that
> one fails. I am using the command:
>
> pg_dump -p 6432 eware -f D:\Util\pgdump.log
>
> If they did not configure a default password at install, how can I
> set up a superuser acct and password so I can do some admin work
> with this pg database? Right now I have no console level access
> to this thing.
You might want to temporarily modify pg_hba.conf or pgpass to get
through this, and then review how you want to handle security long
term (which *might* involve making your emergency fix permanent).
http://www.postgresql.org/docs/current/interactive/auth-pg-hba-conf.htmlhttp://www.postgresql.org/docs/current/interactive/libpq-pgpass.html
-Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, grclark78@gmail.com
Subject: Re: default console user authentication?
In-Reply-To: <4CB479DB02000025000368A9@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox