Hello Admins
Can someone please tell me, which relation gives me the link between a
database and a table?
I want to find out, which table belongs to which database in a cluster.
Something like
SELECT d.datname, c.relname
FROM pg_database d, pg_class c, pg_xxx x
WHERE d.oid = x.oid
AND x.oid
Thanks.
My assumptions seem to have been right. I am connected now. It seems a bit
more open than working directly on the shell-line. The interesting question
is how will I be able to access the databases.
I do have a developers handbook on my desk, but it is a giant of a book.
Regards
Per
"Rob
Hi all,
Is there any way to get back the data if the
database transaction id has wraparound?
Thanks,
I came one step further. Not I get the FATAL, saying that I do not have an
entry in pg_hba.conf for my user and computer.
I gues that I will have to put in a line like:
host all 192.168.1.39 255.255.255.255 trust at the end of
the file - am I right?
Regards
Per
"Robe
Ed Muldowney wrote:
Had to hard reboot server due to server lockup. After postgresql failed
to start. Trying to manually restart postgresql but keep getting FAILED
messages. Nothing in any of the logs to indicate what the error is.
Any ideas on what next steps I should take?
I guess that t
Duffy House wrote:
Hello:
It looks like I got caught sleeping.
I am running Postgresql 7.2 under Red Hat 7.3.
Postgresql failed today. When I tried to restart it, I got a message
stating that the device is full.
I used df to confirm that /var where postgres reside is full. /var is
on a 4 G
Piotr Trawiński wrote:
I have this notorious problem: at some point pgsql simply hangs up and
requires a restart.
May we see the content of pg_stat_activity and the content of
pg_locks ?
I realize my app is very resource hungry but the thing is that it works great
with mysql. The problem occurs on
__
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears/
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
