Re: Restore

In the windows install PG Admin comes packaged with PostgreSQL.

I`m a little confused. My PDW database has postgres as an owner.

You refer to postgres as a user.

My PG Admin shows postgres as a database along with PDW and
template_postgis.

The postgres database probably has a password.

Maybe I need to delete the postgres database.

Bob

-----Original Message-----
From: Adrian Klaver
Sent: Friday, December 24, 2010 4:27 PM
To: Bob Pawley
Cc: pgsql-general(at)postgresql(dot)org ; bricklen
Subject: Re: [GENERAL] Restore

On Friday 24 December 2010 4:20:13 pm Bob Pawley wrote:
> Version 8.4.1
> OS Win 7
> I connect through PG Admin (plus an interface I use when the database is
> up
> and running)
> The password for this connection is the password I set up during the
> installation. this is the same password I am using for the restore
> connection.

The installation of what Postgres or PgAdmin?
I don't use PgAdmin so I going out on a limb here. Is there a way in PgAdmin
to
look at users? If so it should show you whether the postgres user has a
password.

> I haven`t done anything for the postgres user other than what PG Admin
> uses.
>
> Bob

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com