Hello All,
We have a postgres setup on solaris 10 with sun cluster for HA purposes.
2 nodes are configured in the cluster in active-passive mode with
pg_data stored on external storage. Everything is working as expected
however, when we either switch the resource group from one node to other
or rg
Daniel Rubio <[EMAIL PROTECTED]> writes:
> Now I see that theres is not pg_dumplo on contrib directory for 8.2.4
That's because it's obsolete --- regular pg_dump can handle large
objects now.
regards, tom lane
---(end of broadcast)
Daniel Rubio <[EMAIL PROTECTED]> writes:
> If I log via psql using the postgres user via psql there's no problem,
> but If I try to log as a different user, the postmaster process hangs
> and I can't connect.
That's not a hang, it's a core dump. Can you get a stack trace with
gdb or local equiv
Hi,
I want to know what transactions are going on the server ?
>From pg_stat_activity I am able to monitor for only Super User. I have
enabled the Stats_command_string also.
In the column current_query its only showing values for Super User only.
Why not for normal user.
Thanks & Regar
Hi again, a different question ...
On a previous upgrade to 7.4 (I think) I used the pg_dumplo contrib
utility to add the large objects to my restored via pg_dumpall databases
(not all using large objects).
I liked it because it was easy and I hadn't to remove the databases with
large objects
Hi all
I'm experiencing a weird situation with my test installation for 8.2.4.
I installed with no problems on Solaris 10, and I've imported my
databases and users from a 7.4.14 using the 8.2.4 pg_dumpall without
excessive problems (some things about permissions on some tables, but I
think it'
