From: | Vibhor Kumar <vibhor(dot)aim(at)gmail(dot)com> |
---|---|
To: | Sandy Test <sandy(at)mcw(dot)co(dot)il> |
Cc: | <pgsql-general(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: FW: backup using pg_dump postgreSQL 8.3.8 |
Date: | 2011-03-09 14:10:06 |
Message-ID: | 1F229316-6442-4E01-8254-CDBF7B84485F@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
On Mar 9, 2011, at 7:28 PM, Sandy Test wrote:
>
> We have postgreSQL 8.3.8 installed on a windows 8 server (64 bit).
>
> We want to be able to run a nightly backup using the pg_dump command.
> Unfortunately, even with the pg_hba.conf fix of adding host postgres … trust,
> It still asks for a password.
>
> 1. Is this a 64bit issue? If the server was 32bit, would it not ask for a password?
I haven;t seen issue with PG 8.3.8
Please share pg_hba.conf file entry.
> 2. Is there a way of running a dos script that would run the pg_dump providing a password when prompted?
Include following in dos script.
set PGPASSWORD=<passowrd>
Or you can use pgpass.conf file option.
> 3. Is there a way of running the pg_dump with a user that doesn't have a password?
For that user, you have to mention trust with hostname in pg_hba.conf
Thanks & Regards,
Vibhor Kumar
vibhor(dot)aim(at)gmail(dot)com
Blog:http://vibhork.blogspot.com
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2011-03-09 14:38:01 | Re: Advise on dropping TEMP table/schema for my use case |
Previous Message | Sandy Test | 2011-03-09 13:58:20 | FW: backup using pg_dump postgreSQL 8.3.8 |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2011-03-09 14:12:27 | Re: Copying data from one table to another - how to specify fields? |
Previous Message | Michael Glaesemann | 2011-03-09 14:05:39 | Re: Copying data from one table to another - how to specify fields? |