Kasia Tuszynska writes:
> Does anyone know how to check the locale of a cluster?
"show lc_collate" has worked since 7.4.
> The documentation has yielded this " You can check the LC_COLLATE and
> LC_CTYPE settings of a database with the contrib/pg_controldata utility
> program."
The docs have
Hi Everybody,
I am comparing selection results between postgres clusters on RHEL4 and Windows
Server 2003.
The query is:
select count(*)from schema.table where route < 'Interstate 12'
on the RHEL machine the result has: 102 records
on the windows machine the result has: 586 records
the entire t
Look into zero damaged pages setting.
On Wed, Feb 18, 2009 at 2:35 PM, Michael Monnerie
wrote:
> I have the impression I'm asking the wrong things. Still I try.
> Could I do something about this?
>
> psql:/tmp/x:119: ERROR: invalid page header in block 973698 of relation
> "pg_toast_1281127"
>
>
I have the impression I'm asking the wrong things. Still I try.
Could I do something about this?
psql:/tmp/x:119: ERROR: invalid page header in block 973698 of relation
"pg_toast_1281127"
It seems that toast table got truncated after host+XEN crash and XFS
recovery. Would adding some zeroes to t
Tom Lane schrieb:
> Peter Hinse writes:
>> More info: the statement is an INSERT with some huge subselects, running
>> every night on a PGSQL 8.3.6 on CentOS 4.7 x86_64. In 97% of all
>> occasions, the job terminates in about 1-2 minutes - however, sometimes
>> it just hangs. If terminated with ki
Hi All,
Anyone has a good working copy of psqlrc file to nice configure psql
behavior.
Thank you
Isabella
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Thank you , that worked!
Isabella
Ray Stell wrote:
btw, no dump is required to flip from 8.3x to 8.3x, but
testing is a good thing.
check the postmaster.pid
[postgre...@swallowtail alerts_oamp]$ cat postmaster.pid
2545
/var/database/pgsql/alerts_oamp
5478001 0
alerts_oamp]$ ps -ef
btw, no dump is required to flip from 8.3x to 8.3x, but
testing is a good thing.
check the postmaster.pid
[postgre...@swallowtail alerts_oamp]$ cat postmaster.pid
2545
/var/database/pgsql/alerts_oamp
5478001 0
alerts_oamp]$ ps -ef | grep 2545
500 2545 1 0 Jan11 ?00:0
Hi All,
I'm testing for the first time a PG upgrade process, presently running
8.3.4 and try to upgrade to 8.3.6. I have installed 8.3.6 in separate dir
- run pg_dumpall using the new PG 8.3.6 version
- shutdown the server
- create a new db cluster with 8.3.6 initdb
-copy pg_gba.conf and pos
