| Lists: | pgsql-novice |
|---|
| From: | Wye Jon Lee <wyejonlee(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Question regarding pg_restore |
| Date: | 2005-09-23 08:22:24 |
| Message-ID: | dfcfab970509230122bb6261f@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
This is my first post to ANY mailing list so apologies in advance if I
screw up anywhere.
I'm using the pg_restore utility in PostgreSQL 8.0.3 with the following command:
pg_restore.exe -i -h localhost -p 5432 -U "username" -d databasename
-v "outputfile.backup"
pg_restore prompts me for a password and no matter what I key in it
fails my login. Looking at the pg_hba.conf file, I find my settings
configured as:
host all all 127.0.0.1/32 md5
It looks to me that the pg_restore program is expecting me to enter an
MD5 sum as the password. Due to the limitiation of my project's
requirement I'm not allowed to meddle with the pg_hba.conf file. Does
anyone know the correct method to generate an MD5 hash for the
password so that I may pass it in to pg_dump using the command line?
Regards.
--
visit my blog: http://wp.peachjon.com
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Wye Jon Lee <wyejonlee(at)gmail(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Question regarding pg_restore |
| Date: | 2005-09-23 14:04:04 |
| Message-ID: | 3410.1127484244@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
Wye Jon Lee <wyejonlee(at)gmail(dot)com> writes:
> I'm using the pg_restore utility in PostgreSQL 8.0.3 with the following command:
> pg_restore.exe -i -h localhost -p 5432 -U "username" -d databasename
> -v "outputfile.backup"
> pg_restore prompts me for a password and no matter what I key in it
> fails my login.
pg_restore's support for password prompting is broken on Windows in
8.0.3 :-(. It'll be fixed again in 8.0.4. Sorry about that. In the
meantime you could use a ~/.pgpass file (see documentation).
regards, tom lane
| From: | Wye Jon Lee <wyejonlee(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Question regarding pg_restore |
| Date: | 2005-09-26 06:36:55 |
| Message-ID: | dfcfab970509252336794c3a19@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
Hi Tom,
Any indication of when PostgreSQL 8.0.4 will be out?
Regards.
On 9/23/05, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Wye Jon Lee <wyejonlee(at)gmail(dot)com> writes:
> > I'm using the pg_restore utility in PostgreSQL 8.0.3 with the following command:
>
> > pg_restore.exe -i -h localhost -p 5432 -U "username" -d databasename
> > -v "outputfile.backup"
>
> > pg_restore prompts me for a password and no matter what I key in it
> > fails my login.
>
> pg_restore's support for password prompting is broken on Windows in
> 8.0.3 :-(. It'll be fixed again in 8.0.4. Sorry about that. In the
> meantime you could use a ~/.pgpass file (see documentation).
>
> regards, tom lane
>