From: | "Bob Pawley" <rjpawley(at)shaw(dot)ca> |
---|---|
To: | "bricklen" <bricklen(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Restore |
Date: | 2010-12-25 00:03:52 |
Message-ID: | F2F739FF40F241F6A51C480854ABA58D@BobPC |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have tried this a number of times -
psql –U postgres PDW < PDW_June_10.sql. (with and without spaces between U &
postgres and/or < and PDW_June)
Sometimes I am asked for a postgres password, once I was asked for the PDW
password (this makes sense and which I did enter).
When I entered the password it either said password failed or it simply went
back to the root command.
No database information was sent.
pg_hba.conf sets method as md5
I don't know what is meant by your reference to \1.
Bob
-----Original Message-----
From: bricklen
Sent: Friday, December 24, 2010 3:47 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Restore
On Fri, Dec 24, 2010 at 3:38 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
wrote:
> On Friday 24 December 2010 3:28:38 pm Bob Pawley wrote:
>> Thanks Adrian but
>>
>> psql –U postgres -d PDW -f PDW_June_10.sql
>>
>> asks - "Password for user postgres:"
>>
>> When I type the password the cursor doesn't respond and on enter I get
>> password failed.
>>
>> Bob
>>
>
> A little bit of testing on my part showed that your form of connecting
> should
> work also i.e.psql –U postgres PDW < PDW_June_10.sql.
> A couple of questions.
> Can you connect to a database using psql and -U postgres?
> Does the postgres user have a password?
> If you can connect to a database with psql what does \l show? What I am
> looking
> for is whether PDW has its case preserved or not?
How about the pg_hba.conf setting? Is it set to something like md5?
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2010-12-25 00:09:11 | Re: Restore |
Previous Message | bricklen | 2010-12-24 23:47:34 | Re: Restore |