[ADMIN] Autovacuum seems to block database: WARNING worker took too long to start

Hi all, I'm having a strange problem with postgres autovacuum Everything is working fine until I start getting the following errors ... and postgres stops working shortly after (it stops accepting connections) 2010-11-13 12:34:08.599 CET|1|||7104||4cde77b0.1bc0|2010-11-13 12:34:08

[ADMIN] Find all running postgres DB servers on a network

Hi, I wanted to know if there is a way to get the hostnames of all the systems running PostGres DB servers on a local network on Windows (XP/Vista/7) using JDBC or any other Java API ? Regards, Ojas

[ADMIN] Postgres error: could not open relation base/xxxxx/yyyyy

Hi all, We've been using postgres for 9 years without a problem until now! Two problems in a very short time! The first one is described in http://postgresql.1045698.n5.nabble.com/Autovacuum-seems-to-block-database-WARNING-worker-took-too-long-to-start-td3264261.html This is another one (not

Re: [ADMIN] Postgres error: could not open relation base/xxxxx/yyyyy

Stop using the system immediately, since many things inserted to the DB might simply be garbage. Inspect your memory with memtest86. I would even suggest moving to a new HW if available, and start working into two parallel directions: a) try to bring your DB into a sane state b) try to fix

Re: [ADMIN] Postgres error: could not open relation base/xxxxx/yyyyy

Hi Achilleas, Thanks for your quick response. We do have backups and a couple of spare servers running in parallel so we're safe in that sense. Thanks for your advice anyway. To run *memtest86 *we have to go to the datacenter and that will take us a few days. Is there anything we can do

Re: [ADMIN] Find all running postgres DB servers on a network

You could try connecting to each possible IP in your network, but to catch each instance, you should also check nostandard (i.e. different from 5432) ports - kind of hacking ...  AFAIK (or read ;-) ) Rendezvous/bonjour was implemented on OS X port only. regards Gerhard On Sun, Nov 14, 2010 at

Re: [ADMIN] Find all running postgres DB servers on a network

On Sun, Nov 14, 2010 at 5:52 PM, ojas dubey ojas.du...@gmail.com wrote: Hi, I wanted to know if there is a way to get the hostnames of all the systems running PostGres DB servers on a local network on Windows (XP/Vista/7) using JDBC or any other Java API ? Regards, Ojas try to scan

Re: [ADMIN] Postgres error: could not open relation base/xxxxx/yyyyy

Whoever did the memory installation, should also have taken care of checking it's working ok. A good idea is to use ECC memory. Does fsck on the remote system run with reporting problems as well?? (it might report problems such as incorrect block counts, missing inodes etc...) Also check for

Re: [ADMIN] GUI ERD/ERM tools?

loupicci...@comcast.net (Lou Picciano) writes: This question from our users keeps coming up... What tools are each of you using for ERD ERM? pgAmin's Graphical Query Builder is helpful, but doesn't address the need. Can any of you recommend specific tools, preferences, etc? I have tended to

[ADMIN] Pre-Allocate tablespace on disk

Hello, I was wondering if there is a way to pre-allocate tablespace on disk before adding data and indexes. My understanding is: PG writes data into files sequentially. If more space is needed, disk space is requested from the OS and if there is space, the OS will give PG a file system block

Re: [ADMIN] Pre-Allocate tablespace on disk

Le 15/11/2010 20:42, Chris Ruprecht a écrit : Hello, I was wondering if there is a way to pre-allocate tablespace on disk before adding data and indexes. My understanding is: PG writes data into files sequentially. If more space is needed, disk space is requested from the OS and if there

Re: [ADMIN] GUI ERD/ERM tools?

Another option is 'Database = Reverse Engineer' in Visio. Sam -Original Message- From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Chris Browne Sent: Tuesday, 16 November 2010 3:06 AM To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] GUI

Re: [ADMIN] Pre-Allocate tablespace on disk

On 11/15/10 11:42 AM, Chris Ruprecht wrote: I was wondering if there is a way to pre-allocate tablespace on disk before adding data and indexes. My understanding is: PG writes data into files sequentially. If more space is needed, disk space is requested from the OS and if there is space, the

[ADMIN] could not map view of backend variables: error code 6

Hi all, I am trying to install Postgres on Windows 7 32 bits. I have tried both 8.4 and 9.0 installers but get the following error in the application log when the service is trying to start: could not map view of backend variables: error code 6 Any ideas what that error means and how

[ADMIN] ignoring data type

Hello I have migrate a application from a server with postgres 8.1 to another with 8.3 in the new server there are some page that doesn't work because seems to want to compare different data type does anyone know if it is a version issue or there is something Im missing? Thanks Octavio the

Re: [ADMIN] ignoring data type

What does a \d on the table 'clamcartga' in both environments say? Can you spot any differences between the 8.1 and 8.3 environments? Sam From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Octavio Sent: Tuesday, 16 November 2010 3:58 PM To:

Re: [ADMIN] ignoring data type

On Mon, Nov 15, 2010 at 10:28 PM, Octavio octaviomai...@yahoo.com wrote: Hello I have migrate a application from a server with postgres 8.1 to another with 8.3 in the new server there are some page that doesn't work because seems to want to compare different data type does anyone know