[ADMIN] pgpool question?

2007-09-20 Thread Charles.Hou
i have installed the pgpool in the server and start it. but how can i know it's working? i means that the clients connected to the database by the pgpool. ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [ADMIN] pgpool question?

2007-09-20 Thread CaT
On Wed, Sep 19, 2007 at 09:59:22PM -0700, Charles.Hou wrote: > i have installed the pgpool in the server and start it. but how can i > know it's working? i means that the clients connected to the > database > by the pgpool. The latest versions of pgpool2 (I don't use pgpool) have connection loggi

[ADMIN] wholly / partially table read into shared buffer

2007-09-20 Thread Григорий Титов
Hello! I am newbie in Postgres, but previously worked with Oracle. Now I am puzzled with heap_blks_hit/heap_blks_read ratio. I make select from table (whose size is larger than shared_buffer) and saw that it was wholly read from disk after second, third and so on runs. Isn't is wrong that RDBMS

[ADMIN] How to update from 8.1 to 8.2 ?

2007-09-20 Thread Josef Springer
Title: Signature Where is the documentation of the steps dto do for updating e.g. from 8.1 to 8.2 ? I have never done this and could not find any docs for. mit freundlichen Grüßen / best regards, Josef Springer (Geschäftsleitung/Management)

Re: [ADMIN] How to update from 8.1 to 8.2 ?

2007-09-20 Thread Milen A. Radev
Josef Springer написа: > Where is the documentation of the steps dto do for updating e.g. from 8.1 to > 8.2 ? > I have never done this and could not find any docs for. [...] http://www.postgresql.org/docs/8.2/static/install-upgrading.html -- Milen A. Radev ---(end of

Re: [ADMIN] How to update from 8.1 to 8.2 ?

2007-09-20 Thread Carol Walter
We just did this. I did a pg_dumpall using 8.1. Then we fired up 8.2 while 8.1 was still running. Uploaded the data to 8.2. Then shut 8.1 down. This allowed us to have the database unavailable for a very short time. Carol On Sep 20, 2007, at 11:58 AM, Milen A. Radev wrote: Josef Spr

Re: [ADMIN] Schedules Running Problem

2007-09-20 Thread Kevin Grittner
>>> On Wed, Sep 19, 2007 at 7:43 AM, in message <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> wrote: > > I have to create a schedule in the Postgres to insert > some data in the table. But before creating this schedule, i create > schedule that create the table in the Database specified.

Re: [ADMIN] How to update from 8.1 to 8.2 ?

2007-09-20 Thread Chris Hoover
On 9/20/07, Carol Walter <[EMAIL PROTECTED]> wrote: > > We just did this. I did a pg_dumpall using 8.1. Then we fired up > 8.2 while 8.1 was still running. Uploaded the data to 8.2. Then > shut 8.1 down. This allowed us to have the database unavailable for > a very short time. > > Carol Car

Re: [ADMIN] Moving database install to new SAN

2007-09-20 Thread Chris Hoover
> > > 2. copy whole data directory over to new SAN > If database is big, then I think that is much faster to copy running > database > to new SAN. > Then stop postgres and rsync what was changed - but this will be probably > only a few files. I believe if you do this, you will not get a function

Re: [ADMIN] Moving database install to new SAN

2007-09-20 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chris Hoover wrote: >>> 2. copy whole data directory over to new SAN >> If database is big, then I think that is much faster to copy running >> database >> to new SAN. >> Then stop postgres and rsync what was changed - but this will be probably >> only

[ADMIN] How to repair if file pg_clog/0000 is deleted

2007-09-20 Thread xmuinn
Files under directory pg_clog are deleted. How to rebuild files under the directory? ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your