Unix Technical Forum

BUG #2433: Using pg_dump in a .bat : Cannot avoid asking for user Name and Password

This is a discussion on BUG #2433: Using pg_dump in a .bat : Cannot avoid asking for user Name and Password within the pgsql Bugs forums, part of the PostgreSQL category; --> The following bug has been logged online: Bug reference: 2433 Logged by: Jacques Gollion Email address: jgollion@sambatechnologies.com PostgreSQL version: ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Bugs

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-10-2008, 10:59 AM
Jacques Gollion
 
Posts: n/a
Default BUG #2433: Using pg_dump in a .bat : Cannot avoid asking for user Name and Password


The following bug has been logged online:

Bug reference: 2433
Logged by: Jacques Gollion
Email address: jgollion@sambatechnologies.com
PostgreSQL version: 8.1.3
Operating system: Windows 2000 SP4 Fr
Description: Using pg_dump in a .bat : Cannot avoid asking for user
Name and Password
Details:

I am trying to automatically save my database every day using the scheduled
Tasks manager.
I put pg_dump command in a .bat file containing the following line :
C:\postgres\bin\pg_dump -U im -h localhost -Z 0 -u -v -F c -f
F:/backup/dump/backup110506__ano pdb2000

The windows user name is im. There is a database role that is im. In the
directory C:\Documents and Settings\im\Application Data\postgresql there is
a file named pgpass.conf containing the following lines :
localhost:*:*:im:imhe
localhost:5432:*ostgres:imhe

I have checked with sysint/filemon.exe that the file pgpass.conf is read.

In fact I have just to type 'Enter' twice to start dump.

I do not understand what is wrong in my system to avoid typing anything.

Thank you in advance for your help.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 06:20 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com