pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PGPASSWORD
6+ messages / 5 participants
[nested] [flat]

* PGPASSWORD
@ 2006-02-23 19:43  Mr. Dan <bitsandbytes88@hotmail.com>
  0 siblings, 3 replies; 6+ messages in thread

From: Mr. Dan @ 2006-02-23 19:43 UTC (permalink / raw)
  To: pgsql-admin

Hi,

When I was running 8.0.X on linux, I didn't have to include the postgres -P 
password in my shell scripts(.sh).  After I switched to 8.1.X, I've had to 
include the -P PASSWORD ****** in all my scripts.  I'm thinking I'll just 
add PGPASSWORD as a postgres environment variable instead.   I did start 
running 8.1.X on a port that is different from the default, so I added 
PGPORT as an environment variable, so I don't have to include -p PORT 
NUMBER.  Has anyone else noticed they had to start including a password for 
the postgres user in 8.1.X?  Is there any concern to adding PGPASSWORD as an 
environment variable.

Thanks for any feedback,
~DjK





^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: PGPASSWORD
@ 2006-02-23 20:43  Milen A. Radev <milen@radev.net>
  parent: Mr. Dan <bitsandbytes88@hotmail.com>
  2 siblings, 1 reply; 6+ messages in thread

From: Milen A. Radev @ 2006-02-23 20:43 UTC (permalink / raw)
  To: pgsql-admin

Mr. Dan написа:
> Hi,
> 
> When I was running 8.0.X on linux, I didn't have to include the postgres
> -P password in my shell scripts(.sh).  After I switched to 8.1.X, I've
> had to include the -P PASSWORD ****** in all my scripts.  I'm thinking
> I'll just add PGPASSWORD as a postgres environment variable instead.   I
> did start running 8.1.X on a port that is different from the default, so
> I added PGPORT as an environment variable, so I don't have to include -p
> PORT NUMBER.  Has anyone else noticed they had to start including a
> password for the postgres user in 8.1.X?  Is there any concern to adding
> PGPASSWORD as an environment variable.
> 

See the paragraph about "PGPASSWORD" at
http://www.postgresql.org/docs/8.1/static/libpq-envars.html - it
recommends the use of "~/.pgpass" file.


BTW I can't seem to find any reference to a "-P" parameter related to
supplying a password.


-- 
Milen A. Radev




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: PGPASSWORD
@ 2006-02-23 20:55  Mr. Dan <bitsandbytes88@hotmail.com>
  parent: Milen A. Radev <milen@radev.net>
  0 siblings, 1 reply; 6+ messages in thread

From: Mr. Dan @ 2006-02-23 20:55 UTC (permalink / raw)
  To: pgsql-admin



Thanks Milen!

I use -P is bash shell scirpts.  It used with with pgbench.
see pgbench --help.

~DjK





^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: PGPASSWORD
@ 2006-02-23 21:23  Jim C. Nasby <jnasby@pervasive.com>
  parent: Mr. Dan <bitsandbytes88@hotmail.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Jim C. Nasby @ 2006-02-23 21:23 UTC (permalink / raw)
  To: Mr. Dan <bitsandbytes88@hotmail.com>; +Cc: pgsql-admin

Depending on your actual config, you could well be able to set
postgresql up so that it doesn't need any passwords, too. I prefer this
when possible... but you need to understand the rammifications if you
care about your data.

Though, if all you're doing is running pgbench, I'd say just setup
everything for TRUST and be done with it... ;)

On Thu, Feb 23, 2006 at 03:55:28PM -0500, Mr. Dan wrote:
> 
> 
> Thanks Milen!
> 
> I use -P is bash shell scirpts.  It used with with pgbench.
> see pgbench --help.
> 
> ~DjK
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
> 

-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: PGPASSWORD
@ 2006-02-23 21:45  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Mr. Dan <bitsandbytes88@hotmail.com>
  2 siblings, 0 replies; 6+ messages in thread

From: Tom Lane @ 2006-02-23 21:45 UTC (permalink / raw)
  To: Mr. Dan <bitsandbytes88@hotmail.com>; +Cc: pgsql-admin

"Mr. Dan" <bitsandbytes88@hotmail.com> writes:
> Has anyone else noticed they had to start including a password for 
> the postgres user in 8.1.X?

No.  I'll bet a very good dinner that you changed the pg_hba.conf
configuration file when you updated the PG installation.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: PGPASSWORD
@ 2006-02-23 23:08  Andy Shellam <andy.shellam@mailnetwork.co.uk>
  parent: Mr. Dan <bitsandbytes88@hotmail.com>
  2 siblings, 0 replies; 6+ messages in thread

From: Andy Shellam @ 2006-02-23 23:08 UTC (permalink / raw)
  To: Mr. Dan <bitsandbytes88@hotmail.com>; +Cc: pgsql-admin

Look at your pg_hba.conf file - your old configuration might have had a 
"trust" authentication set somewhere for your local machine/network IPs, 
rendering any password unnecessary.

Andy

Mr. Dan wrote:
> Hi,
>
> When I was running 8.0.X on linux, I didn't have to include the 
> postgres -P password in my shell scripts(.sh).  After I switched to 
> 8.1.X, I've had to include the -P PASSWORD ****** in all my scripts.  
> I'm thinking I'll just add PGPASSWORD as a postgres environment 
> variable instead.   I did start running 8.1.X on a port that is 
> different from the default, so I added PGPORT as an environment 
> variable, so I don't have to include -p PORT NUMBER.  Has anyone else 
> noticed they had to start including a password for the postgres user 
> in 8.1.X?  Is there any concern to adding PGPASSWORD as an environment 
> variable.
>
> Thanks for any feedback,
> ~DjK
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>
> !DSPAM:43fe0ff820151195621447!
>
>





^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2006-02-23 23:08 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-23 19:43 PGPASSWORD Mr. Dan <bitsandbytes88@hotmail.com>
2006-02-23 20:43 ` Milen A. Radev <milen@radev.net>
2006-02-23 20:55   ` Mr. Dan <bitsandbytes88@hotmail.com>
2006-02-23 21:23     ` Jim C. Nasby <jnasby@pervasive.com>
2006-02-23 21:45 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-02-23 23:08 ` Andy Shellam <andy.shellam@mailnetwork.co.uk>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox