Re: [ADMIN] PANIC: unable to locate a valid checkpoint record

2003-02-20 Thread Tom Lane
Ganesan R <[EMAIL PROTECTED]> writes: > I am using 7.3.2. postmaster prints this on starting up: > LOG: ReadRecord: bad resource manager data checksum in record at 0/E42144 > pg_resetxlog is able to recover from the problem; but I am concerned because > I can reproduce the scenario very easily.

Re: [ADMIN] DIFERENCE pg_stat_* pg_statio_*

2003-02-20 Thread Robert Treat
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=monitoring-stats.html On Sun, 2003-02-16 at 21:43, Eduardo wrote: > Which is the diference between that system tables? > > Which is their objetive? > > Thanks. ---(end of broadcast)

Re: [ADMIN] dumpBlobs(): could not open large object: ERROR:

2003-02-20 Thread Robert Treat
It sounds like your binary files may have been deleted. The output of \lo_list in psql should tell you what valid large objects you have. Robert Treat On Wed, 2003-02-19 at 14:02, Tim Lynch wrote: > version(): PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96 > redhat 7.3 > > i've mad

Re: [ADMIN] using multiple sort orders in one database

2003-02-20 Thread Antti Haapala
On Thu, 20 Feb 2003, prime factory: Michael Jürgens wrote: > I have to a multilanguage website with postgres 7.3 as backend. > This website uses english, german, and turkey as languages, so I have to > use different sort orders in my queries. > > So far I understood the docs, I have to set the co

[ADMIN] using multiple sort orders in one database

2003-02-20 Thread prime factory: Michael Jürgens
Hi, I have to a multilanguage website with postgres 7.3 as backend. This website uses english, german, and turkey as languages, so I have to use different sort orders in my queries. So far I understood the docs, I have to set the correct language settings when executing initdb. But how can I s

[ADMIN] using multiple sort orders in one database

2003-02-20 Thread prime factory: Michael Jürgens
Hi, I have to a multilanguage website with postgres 7.3 as backend. This website uses english, german, and turkey as languages, so I have to use different sort orders in my queries. So far I understood the docs, I have to set the correct language settings when executing initdb. But how can I sup

[ADMIN] PANIC: unable to locate a valid checkpoint record

2003-02-20 Thread Ganesan R
Hi, I am using 7.3.2. postmaster prints this on starting up: LOG: database system was interrupted at 2003-02-20 14:23:36 IST LOG: ReadRecord: bad resource manager data checksum in record at 0/E42144 LOG: invalid primary checkpoint record LOG: ReadRecord: bad resource manager data checksu

[ADMIN] Logging for psql only

2003-02-20 Thread Al Sutton
Hi, Does anyone have a solution to the following situation;   I have an application which uses postgresql as its database, I also have technicians who need to made occasional data changes using psql, is there any way to log the changes made by the technicians without logging the SQL stateme

Re: [ADMIN] Insert Error

2003-02-20 Thread Nick Fankhauser
It means you need to give that error message to your system administrator, who will understand what it means. If you are the system administrator, use "df" to learn which filesystem is full & then spend some time learning about filesystem management so you can fix it. -Nick > -Original Mess