You can probably do something like this while running as root:
you might want to double check your pg_hba file to make sure it is correct. That will definitely stop you if it has been messed with
netstat -tp | grep postgresql
I haven't run two dbms instances on the same machine before so I can't advise anything there. I imagine the just run independently though so it shouldn't be an issue. Just check the configs for each.
What have you tried to backup the db? Have you just used the web admin interfaces to do that in the past? (I am guessing this is the case)
You can get on the machine and sudo over to the postgres user. Then you can run the backup commands for each db or each db cluster.
I guess you just want to backup the individual dbs. Something like this works, but you should double check the manual to make sure its what you want.. (This is in reference to 8.2 mostly. I am not sure if it is similar with 7.2 but I -think- the programs will handle older version, but I am not sure)
This is a very basic DB backup.
You will need to run pg_restore to put the data back.
pg_dump -d <dbname> -f <fileout>
But those only backup individual dbs.. if you have multiple dbs running on the cluster then you could do a pg_dumpall
pg_restore -d <dbname> < <filein>
Since you are running different versions you should look in the manuals for each to make sure there are no little problems in doing backups I simply can't warn you about what you might encounter here.
pg_dumpall > <outfile>
My guess is that a config file is just wonky and once you set it correctly it will work. Or, as loquin suggests, check you connections to make sure they are bieng released properly. I have noticed on our server (Ubuntu) that every once in awhile a tcp connection will stay open when it shouldn't. We are not sure of the cause, but we kill off the process and it goes away. This hasn't caused any issues for us since it is rare and usually only 1 zombie connection.
If you get any more diagnostic info post it and we can take a look. I am new to a lot of this stuff myself, so I will try to help, but PLEASE look in the documentation hehe.
Edit: forgot to add that I think the command you want is pg_ctlcluster (although I am not sure if this works for 7.2). I usually just do ./init.d/postgresql-V.X reload/restart/stop hehe
Last edited by amthomas; 10-29-07 at 15:32.
Vi veri veniversum vivus vici
By the power of truth, I, a living man, have conquered the universe