Skip site navigation (1) Skip section navigation (2)

Re: Pg_dump options

From: Gurudutt <guru(at)indvalley(dot)com>
To: Troy(dot)Campano(at)LibertyMutual(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Pg_dump options
Date: 2002-01-29 05:34:17
Message-ID: 805673457.20020129110417@indvalley.com (view raw or flat)
Thread:
Lists: pgsql-general
Hello Troy,

You could use one of these things to get it working..

Create one txt file, input the username and password in different
lines like

Username
Password

save the file(user.txt)...

Give this file as input to the pg_dump it should work

pg_dump dummy_db < user.txt > /tmp/dummy_db.sql


Hope it solves the problem, it worked for me...

Gurudutt


Tuesday, January 29, 2002, 12:38:07 AM, you wrote:

TCLc> Is there a way to supply a username and password in one command using
TCLc> pg_dump?


TCLc> For example is it possible to do this so it doesn't prompt you for a
TCLc> username/password:



TCLc> pg_dump mydb --username=dbuser --password=dbpass > myfile.out



TCLc> Thank you!

[:==>> Troy Campano <==:]




-- 
Best regards,
 Gurudutt                            mailto:guru(at)indvalley(dot)com

Life is not fair - get used to it.
Bill Gates


In response to

Responses

pgsql-general by date

Next:From: Lamar OwenDate: 2002-01-29 05:36:06
Subject: Re: 7.2 RPMs (Re: [HACKERS] PostgreSQL v7.2rc2 Released)
Previous:From: Jason WatkinsDate: 2002-01-29 05:28:56
Subject: Re: Moving my business to PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group