Hi,
I've only just started doing WAL backups, and so far am not able to
keep a running backup due to lack of hardware.
Obviously I gzip the WAL fioles, but I'm fast running out of disk
space. I have a second standy server with 200GB disk, where I store
the compressed WAL files, which quickly fills
Hi Team,
I am using Solaris9 and pgsql 8.2.5. Started the DB with the option 50
nodes and 100 blocks as below.
pg_ctl start -D /db1/postgresql/data -o "-N 50 -B 100 -i"
When started, there are 3 processes running with postgres names. After
that when a single transaction comes to the DB,
On Mon, Feb 18, 2008 at 06:30:38PM +0530, Suresh Gupta VG wrote:
> Can you please any one explain, how the processes will go when we give
> the options for blocks and nodes. As a common, we find 3 processes
> running as parent processes of pgsql. Pls find the list of processes in
> the attachment.
Pattu, Susanta Kumar wrote:
Hello,
I am trying to install postgresql-8.2.4 on (Remote Server) with
Windows Server 2003 (pack 1).
I use the postgresql-8.2.msi installer with:
- national language support, PL/java, Development files selected
- install a service option checked with postgres u
Hello all,
I am new to postgresql. i am working on the PITR replication system. I have
successfully implemented the standby database. I have tested the log
shipment and the recovery process on the standby. everything is workign
fine.
Please guide me how to bring the standby database in open mode
Hello all,
I have a problem with a trigger which is executed when i make an UPDATE trought
a simple query, but
not when the UPDATE is made in a store procedure.
Maybe i'm missing something in the declaration of the function and i would
appreciate any help.
T
his is the function:
CREATE OR REPL
On 2/18/08, Brian Modra <[EMAIL PROTECTED]> wrote:
>
> I've only just started doing WAL backups, and so far am not able to
> keep a running backup due to lack of hardware.
> Obviously I gzip the WAL fioles, but I'm fast running out of disk
> space. I have a second standy server with 200GB disk, whe
Hi,
Hope, this is the right mailing list.
I installed postgres on Windows XP, as previledged user (so I have access).
I did not install it as a service. The database won't start after selecting
"Start database" from Start Menu.
The output:
C:\Program Files\PostgreSQL\8.3\bin>"C:\Pr
Hello list!
We use postgresql as a backend to our email gateway, and keep al
emails for in database. Using postgres version 7.4.8 (yes, i know it's
old), and rather specific table schema (the application was desined
that way) -- all emails split into 2kb parts and fed up into
pg_largeobject. So, l
Hello,
I am trying to install postgresql-8.2.4 on (Remote Server) with Windows
Server 2003 (pack 1).
I use the postgresql-8.2.msi installer with:
- national language support, PL/java, Development files selected
- install a service option checked with postgres user
- initialize database clu
Hello,
I am trying to install postgresql-8.2.4 on (Remote Server) with Windows
Server 2003 (pack 1).
I use the postgresql-8.2.msi installer with:
- national language support, PL/java, Development files selected
- install a service option checked with postgres user
- initialize database cluste
Before starting the DB Server you have to create a Data directory. use the
initdb command -
Create a DATA folder under 8.3 folder , Give proper privileges to Postgres user
on the Data folder and then use
C:\Program Files\PostgreSQL\8.3\bin\initdb -D "C:\Program
Files\PostgreSQL\8.3\data"-
On 18/02/2008, Vladimir Rusinov <[EMAIL PROTECTED]> wrote:
>
>
> On 2/18/08, Brian Modra <[EMAIL PROTECTED]> wrote:
> > I've only just started doing WAL backups, and so far am not able to
> > keep a running backup due to lack of hardware.
> > Obviously I gzip the WAL fioles, but I'm fast running ou
On Montag, 18. Februar 2008 Brian Modra wrote:
> Thats pretty much what I'm doing already but the problem is that I'm
> quickly running out of disk space on the remote server.
Then buy some disks for it, where's the problem?
mfg zmi
--
// Michael Monnerie, Ing.BSc- http://it-managem
I have an application who is client/server instaled with hundred of
users where every user of the aplication have one user registred in
the database. The aplication and PostgreSQL is working fine and we use
some roles to grant access in every object that some groups need to
use.
The problem is that
Fabio Telles wrote:
In Oracle, we use the clause 'set role identified by some_password'.
How could I handle these problem. Any clue?
Normally these role passwords in Oracle are used (and stored) on a
middle tier, and not put into the hands of the client. So where are you
storing this role
Hallo,
I'm using fedora 8 and I have problems to run 8.2 and 8.3 parallel on the same
computer . Is it realy necessary to run pg_dumpall with 8.3.
With kind regards
Alfred
On Feb 18, 2008 2:02 PM, Alfred Langer <[EMAIL PROTECTED]> wrote:
>
> Hallo,
>
> I'm using fedora 8 and I have problems to run 8.2 and 8.3 parallel on the
> same computer . Is it realy necessary to run pg_dumpall with 8.3.
I'm afraid I'm not entirely sure if you're asking two unrelated
questions o
Hello ,
Go through this below mentioned link
http://archives.postgresql.org/sydpug/2006-10/msg1.php
_
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of libra dba
Sent: Friday, February 15, 2008 4:11 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Failover of th
19 matches
Mail list logo
