[ADMIN] DB Cluster hanging

ormal behaviour when the logfile destination fills up? There was nothing in the logfile being used at the time of the hang, just stats data. PG version 8.0.3 with archived WAL logs enabled O/S version RH ES4 with 2 CPUs & 2Gb RAM Thanks very much for any input. Regards, Nig

Re: [ADMIN] DB Cluster hanging

Y-%m-%d_%H%M%S.log' Thanks, Nigel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane Sent: 13 October 2005 17:12 To: Nigel Bishop Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] DB Cluster hanging Nigel Bishop <[EMAIL PROTECTED]>

[ADMIN] DB cluster hanging

nput.     Regards,   Nigel Bishop   Communications on or through ioko's computer systems may be monitored or recorded to secure effective system operation and for other lawful purposes.Unless otherwise agreed expressly in writing, this communication is to be treated as confidential and the informat

[ADMIN] Hot Standby DB solution

Hello list,   RH 4 PG 8.0.3   I’m investigating the use of a second server with a backup copy of the live DB set up and in recovery mode.   I want to copy (scp?) the archived WAL files over and apply these to the standby DB.   Basically what I am after is any documentation on how t

[ADMIN] PG & AMD 64bit

Hi,   Does anyone know of any issues running PG8.0 / Redhat 4 on a HP-385 with 64bit AMD procs   Thanks   Nigel   Communications on or through ioko's computer systems may be monitored or recorded to secure effective system operation and for other lawful purposes.Unless otherwise

[ADMIN] Question about Shared memory and PG

Hi,   Bit of background:   PGPOOL (V8 with PG 803) talking to 2 x Red Hat ES4, HP DL 380s with 2Gb RAM and twin CPUs running PG 807   Last night PGPOOL alerted our OOH on call guy saying that it could communicate with the second DB server   In the PG log file the errors were:   20

[ADMIN] Some advice required please

Hi,   I’ve just inherited a PG DB (7.3.10 on RH 2.4.21 )   Chatting to the person who administered(?) the DB prior to me I discovered that it had never been vacuumed/analyzed…   When performing a vacuum/analyze on the template1 DB I got the following at the end:   WARNING:  Some dat

Re: [ADMIN] Some advice required please

OK thanks Tom -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: 30 August 2006 14:48 To: Nigel Bishop Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Some advice required please "Nigel Bishop" <[EMAIL PROTECTED]> writes: > Selecting from pg

[ADMIN] Installing plpgsql fails

/opt/postgres/product/7.3.3/lib - and in this directory resides a file called plpgsql.so The LD_LIBRARY_PATH variable also contains /opt/postgres/product/7.3.3/lib I've installed this successfully on another Solaris box without a problem. Has anyone got any thoughts? Thanks R

Re: [ADMIN] Installing plpgsql fails

ct/7.3.3 Could this make a difference I was trying to run the dbsize.sql script which fails (ERROR: stat failed on file '$libdir/plpgsql': No such file or directory) because the language isn't installed hence why I'm trying to install the lanaguage. Regards Nigel Bi

[ADMIN] Installing pgtclsh

I installed PG Ver 7.3.2 on Solaris 8 several months ago and this has been running fine. One of the developers has now asked that the pgtclsh interface be installed. Does this mean that I have to do a ./configure --with-tcl, then make, then install make - or is there another way to do this? W

[ADMIN] ERD tool for postgres?

Hi Has anyone come across a ERD tool for postgres - preferably free Regrads Nigel ---(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

[ADMIN] pg_dump Error

Hi I'm getting an error with pg_dump: I'm using pg_dump -v -C -U username database > ./dumpfile.dmp and it errors with: pg_dump: saving database definition pg_dump: reading namespaces pg_dump: reading user-defined types pg_dump: reading user-defined functions pg_dump: reading user-defined aggr

[ADMIN] Error in logfile on DB startup

Hi Solaris 8, PG 7.4.2 installed from source The DB appears to be running OK I set the following in the pg_conf file to invoke statistics gathering: stats_start_collector = true stats_block_level = true In the logfile after the DB was re-started the following appeared: 2004-07-19 16:25:12 LOG

FW: [ADMIN] Error in logfile on DB startup

Any help would be much appreciated especially with the first problem Thanks, Nigel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nigel Bishop Sent: 20 July 2004 14:50 To: [EMAIL PROTECTED] Subject: [ADMIN] Error in logfile on DB startup Hi Solaris 8

[ADMIN] PG SQL scripts

Hi, Does anyone know of any websites (or care to share) that have PG sql scripts for querying the pg_ views/tables, (there's 000's for Oracle dba_ v$ views). I'm after storage (sizes etc) info regarding the applications tables/indexes, also how can I format the output-ted columns into a more read

[ADMIN] Question about backup/restore

Title: Message Could someone please advise:   I'm new to Postgres (13 years Oracle DBA experience) and I'm trying to understand the nature of Postgres backup/restores.   An example:   If I take a backup (via pg_dump) at 8pm on Wednesday and then on Thursday at 10am I have some form of media

[ADMIN] Installing plpgsql gives error

Ver 7.3.3. The PG S/W was installed from source with the configure --prefix set to a directory of my choosing. There are various *plpgsql* files under the source directories but none under the $PGHOME/lib directories Any help with this would be much appreciated Re