[ADMIN]unsubscribe
__ 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
Re: [ADMIN] Performance failure / automatic restart / cron ?
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 only with pgsql which i realy need. You need pgsql or mysql was not enough ? Please no flames here. Regards Gaetano Mendola ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [ADMIN] device full ---> postgres will not start
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 Gig device. Postgresql is the only application on this machine. Please note, the backup of the database from the prior day, is 45 Meg zipped. I do not know how the database could be soaking up a 4 Gig device. Questions: How can I recover from this situation? Var contain also all log file of your box I guess. Go on your directory data ( on RH is on /var/lib/pgsql/data ) and do : du -sh if is really 4GB move your data directory in another big partition, make a simbolink link with your old location, start postgres and do a vacuum full of your database. if is not really 4GB do a log rotate of your logs. Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [ADMIN] Starting postgresql service FAILED
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 the the line where you start postgres redirect all error on /dev/null ( inside /etc/init.d/postgresql is like this ), so put in place of /dev/null a file and wathc on it . Regards Gaetano Mendola ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [ADMIN] Access with a management tool
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
"Robert Treat" <[EMAIL PROTECTED]> skrev i en meddelelse
news:[EMAIL PROTECTED]
> if it's a pg_hba issue, he should get a FATAL "authentication
> failed"-ish message. I'd check for tcpip_socket=true in postgresql.conf
> first.
>
> Robert Treat
>
> On Fri, 2003-10-24 at 11:00, Oliver Scheit wrote:
> > edit your pg_hba.conf
> >
> > regards,
> > Oli
> >
> > -Ursprüngliche Nachricht-
> > Von: Per Münster [mailto:[EMAIL PROTECTED]
> > Gesendet: Freitag, 24. Oktober 2003 12:32
> > An: [EMAIL PROTECTED]
> > Betreff: [ADMIN] Access with a management tool
> >
> >
> > I have got a tool for managing the postgres from postgres. When trying
to
> > register server and/or database I get the message, that I should check
if
> > the server is listening on 5432. Well, I do not really know. I know only
> > that I've got access from a linux shell, but I am trying to operate from
a
> > windows client.
> >
> > Who can help?
> >
> > Per
> --
> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>
>
> ---(end of broadcast)---
> TIP 7: don't forget to increase your free space map settings
>
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
[ADMIN] Transaction ID wraparound problem
Hi all, Is there any way to get back the data if the database transaction id has wraparound?
Re: [ADMIN] Access with a management tool
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
"Robert Treat" <[EMAIL PROTECTED]> skrev i en meddelelse
news:[EMAIL PROTECTED]
> if it's a pg_hba issue, he should get a FATAL "authentication
> failed"-ish message. I'd check for tcpip_socket=true in postgresql.conf
> first.
>
> Robert Treat
>
> On Fri, 2003-10-24 at 11:00, Oliver Scheit wrote:
> > edit your pg_hba.conf
> >
> > regards,
> > Oli
> >
> > -Ursprüngliche Nachricht-
> > Von: Per Münster [mailto:[EMAIL PROTECTED]
> > Gesendet: Freitag, 24. Oktober 2003 12:32
> > An: [EMAIL PROTECTED]
> > Betreff: [ADMIN] Access with a management tool
> >
> >
> > I have got a tool for managing the postgres from postgres. When trying
to
> > register server and/or database I get the message, that I should check
if
> > the server is listening on 5432. Well, I do not really know. I know only
> > that I've got access from a linux shell, but I am trying to operate from
a
> > windows client.
> >
> > Who can help?
> >
> > Per
> --
> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>
>
> ---(end of broadcast)---
> TIP 7: don't forget to increase your free space map settings
>
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
[ADMIN] Relation from database to filename of e.g. table
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 = c.relfilenode But I did not find the pg_xxx. Thanks Oli ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
