Web Hosting Talk







View Full Version : How to get postgres password???


qhasxeem
12-11-2001, 02:33 PM
I'm trying to RSYNC to back up my RAQ4s.

How do I get the postgres password?

I tried /etc/cobalt/.meta.id and that password does not work. (Unless it's encrypted). :angry:

Anyone know how????

Is there a way to change it w/o affecting the control panel???
F%%$ the warranty on Cobalt!

jks
12-11-2001, 09:09 PM
Originally posted by qhasxeem
I'm trying to RSYNC to back up my RAQ4s.

How do I get the postgres password?

I tried /etc/cobalt/.meta.id and that password does not work. (Unless it's encrypted). :angry:


It _is_ the Postgres password.

Which username is it you're using? (it should be admin)

swissmonk
12-12-2001, 03:16 AM
You have to change the file pg_hba.conf

On a raq 3: /home/pgsql/pg_hba.conf
on a raq 4: /var/lib/pgsql/data/pg_hba.conf

Change local all crypt to local all trust

After that, you can access postgress with the admin passwd

qhasxeem
12-12-2001, 01:55 PM
that sux. :mad:

Here's what I have to do in my script.
1. create a pg_hba.conf with "local all trust "
2. create another pg_hba.conf with "local all encrypt "
3. when running script, copy trust_file to main_file
then after script (pg_dump) done, copy encypt_file to main_file.

That's my solution. There must be a way to dump Postgres besides the above??? :confused:

Anyone know how the COBALT control panel does it???