On Wed, 2008-12-10 at 14:23 +0200, [EMAIL PROTECTED] wrote:
> Hi,
>
> I am using pg 8.3 and configured warm standby server. It is working
> well, but my db is relative big ( ~ 40 GB).
>
> Is it possible to stop running "Warm standby server" and when it
> starts again to continue executing WA
On Wed, Dec 10, 2008 at 12:26 AM, Michael Leshchenko
<[EMAIL PROTECTED]> wrote:
> Dear pg community
>
> I am newbie with PostgreSQL. I have separate table space for my databases,
> which is located in separate folder, which is different to default. I would
> like to carry out file system level back
pg_dumpall has a flag for globals only which dumps an SQL file with
that info. Check it out pg_dumpall --help
On Dec 4, 2008, at 10:55, Chris Curvey <[EMAIL PROTECTED]> wrote:
I'm a newbie to PG administration (although I have experience with
other DBs). I need to move a single database to
Hi,
I am using pg 8.3 and configured warm standby server. It is working
well, but my db is relative big ( ~ 40 GB).
Is it possible to stop running ?"Warm standby server" and? when it
starts again to continue executing WALs from the stop moment.
I'm using following command to stop the ser
Chris Curvey wrote:
I'm a newbie to PG administration (although I have experience with
other DBs). I need to move a single database to a brand new server.
I've set up the new server with initdb, set up pg_hba.conf and
postgresql.conf, and I can use dump and restore to move the database
to the n
VACUUM activiy can make any process size so much heavy...
Suresh Borse wrote:
Hi,
Try to monitor the o/p of following command.
psql > select * from pg_Stat_activity;
It gives all the connection detail.
On Fri, 2008-09-12 at 18:12 +1000, Vivek_Sharan wrote:
Hi Admin,
I’m new to this I
Hi,
Try to monitor the o/p of following command.
psql > select * from pg_Stat_activity;
It gives all the connection detail.
On Fri, 2008-09-12 at 18:12 +1000, Vivek_Sharan wrote:
> Hi Admin,
>
>
>
> I’m new to this I have few queries as listed below
>
>
>
> 1) Number of connection
Hi Mike,
> I am newbie with PostgreSQL. I have separate table space for my
> databases, which is located in separate folder, which is different to
> default. I would like to carry out file system level backup. Do I need
> to backup only folder with my table space or all pg folders.
Do you kno
