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

Re: (Fwd) how to change or set password for a database

From: harrold(at)sage(dot)che(dot)pitt(dot)edu
To: hodges(at)xprt(dot)net
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: (Fwd) how to change or set password for a database
Date: 2001-09-22 19:23:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

in you rdata directory there should be a file called pg_hba.conf. read
through the comments in that file and it should explain access control. on
a side note, are you able to connect to any databases using php? if not
you might not be starting the postmaster with the right options. on older
versions of postgres this was dont by starting the postmaster with the
"-i" option. i dont recall right off hand what it is in 7.1.


"You have new mail, you open it. Your server begins port 
scanning every box on the internet.  Do the server's mind? 
Of course not, they have nothing better to do." 
- New Microsoft Ad?

Sometime in September hodges(at)xprt(dot)net assaulted keyboard and produced...

|I have postgres running on a redhat 7.1 install.  I am getting
|permission denied when trying to run a php script thru
|localhost (php is running also).
|Actually just trying to set up a local copy of a database so
|I can do development work locally.  The remote database has
|a password (the connect script used there includes a password)
|but I can find nothing in the documentation on how to set or
|change a database password.
|Please reply to hodges(at)xprt(dot)net
|Thanks, Tom
|------- End of forwarded message -------
|---------------------------(end of broadcast)---------------------------
|TIP 2: you can get off all lists at once with the unregister command
|    (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

pgsql-novice by date

Next:From: Matthew BraithwaiteDate: 2001-09-22 20:40:15
Subject: Index not used for simple query, and yes I ran vacuum analyze
Previous:From: hodgesDate: 2001-09-22 18:47:55
Subject: (Fwd) how to change or set password for a database

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