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 i
"Mr. Dan" <[EMAIL PROTECTED]> 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
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
ever
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 [EMAIL PROTECTED
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
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 di
