Re: [ADMIN] Regarding postgres 9.1 with Redhat Linux

2011-12-18 Thread Myint
Hi All, Tcp problem already fixed. But now there is serious problem when we query into database by using ./psql -U postgres -d postgres and show as following. ./psql: line 30: 21991 Segmentation fault LD_LIBRARY_PATH=$PG_BIN_PATH/../lib:$LD_LIBRARY_PATH "$PG_BIN_PATH/psql.bin" " Our linu

Re: [ADMIN] Issues with log-shipping replication

2011-12-18 Thread Ray Stell
On Sun, Dec 18, 2011 at 03:57:54PM +, Khusro Jaleel wrote: > On 16/12/2011 00:55, Rural Hunter wrote: > > You are referring to the "master" log file, is this the same log file I am > referring to, or is that is some different location? http://www.postgresql.org/docs/9.1/interactive/runtime-co

Re: [ADMIN] Number of connections still limited on Windows 64-bit?

2011-12-18 Thread Jan-Peter Seifert
Hello Andreas, Am 15.12.2011 18:40, schrieb lst_ho...@kwsoft.de: > Zitat von jan-peter.seif...@gmx.de: >> Original-Nachricht >>> Datum: Thu, 08 Dec 2011 13:04:30 +0100 >>> Von: lst_ho...@kwsoft.de >>> Zitat von Jan-Peter Seifert : >> >>> > I wonder whether the number of connecti

Re: [ADMIN] PostgreSql Startup Error

2011-12-18 Thread Ian Lea
> I am unable to start my PostgreSQL Server. > > When I try to start the service I am getting the error below; > > System Error 5 has occurred > > Access Denied > > Where could I be going wrong because it has happened to me more than one > time and what I do is to reinstall PSQL a fresh. > > I need

[ADMIN] PostgreSql Startup Error

2011-12-18 Thread Brian Mutinda
Hi Team; I am unable to start my PostgreSQL Server. When I try to start the service I am getting the error below; System Error 5 has occurred Access Denied Where could I be going wrong because it has happened to me more than one time and what I do is to reinstall PSQL a fresh. I need a long l

[ADMIN] PostgreSQL Schema Standards Tool

2011-12-18 Thread Robert Matthew Cook
Hello, Is anyone aware of tools which can be used to enforce schema standards on PostgreSQL 9.0? For examples: 1) Fail/rollback DDL attempting to create a table in the public schema 2) Create a scheduled process which raises alerts for columns of datatype XML Thanks, Robert

Re: [ADMIN] Issues with log-shipping replication

2011-12-18 Thread Khusro Jaleel
On 16/12/2011 00:55, Rural Hunter wrote: well, is pgsql capable to parse shell variables in postgresql.conf? anway you should check your master log. If it can not archive the wal, there will be errors reported in it. Hi there, I have removed the various shell variables from the postgresql.conf

Re: [ADMIN] Index error on recovery

2011-12-18 Thread 杨晓青
is your index a hash index? xlog does not include the changes on hash index,your must rebuild hash index after recovery from xlog. 2011/12/16 K P Manoj > Hi > > The details given below is for a test server, that I brought back up from > the base (after running a day worth wals and by giving re