Ivan,
if you have configured WAL archiving, you may want to look at
http://www.postgresql.org/docs/8.1/static/backup-online.html, especially
paragraph '23.3.4. Timelines'.
List: Maybe someone already hacked the postmaster to extract deleted records?!
HTH, Oliver.
-Ursprüngliche Nachricht-
Hi,
I installed postgresql in windows platform. I want to setup the server
and client configuration on this. Kindly help me. (Server and client
configuration). What are the configuration files I have to modify.
Kindly reply ASAP. Waiting for your reply.
Thanks & Regards
Jayakumar M
--- Jayakumar_Mukundaraju <[EMAIL PROTECTED]> wrote:
> I installed postgresql in windows platform. I want to setup the server
> and client configuration on this. Kindly help me. (Server and client
> configuration). What are the configuration files I have to modify.
> Kindly reply ASAP. Waiting fo
No, I do not have WAL archiving.
I hope some one have done the hacking in postmaster.
If no one have done this, my idea was to change the vacuum
(or make e new copy).
I am not familiar with pg code, but as I know by running
vacuum, pg marks deleted records as free, and my idea was to
mark this rec
Hi all,
I have a server with 4GB of RAM and I wanted to know how much memory
is being used by a PostgreSQL. To do so I have executed the following:
ps -A -o rss,vsz,command|grep postgres | awk '{rss += $1; vsz += $2 }
END { print "Real: ",rss/1024"MB Virtual: ",vsz/1024"MB" }'
And the resul
>I have a server with 4GB of RAM and I wanted to know how much memory
> is being used by a PostgreSQL. To do so I have executed the following:
>ps -A -o rss,vsz,command|grep postgres | awk '{rss += $1; vsz += $2 }
> END { print "Real: ",rss/1024"MB Virtual: ",vsz/1024"MB" }'
> And the resul
Hi,
I have moved my database files from their default location to their own
partition on with their own controller and disks. PostgreSQL works OK
and I can connect with Pgadmin (Debian Lenny AMD64, PostgreSQL 8.2.4).
When I want to connect with psql however (with a non-root account) I get
the fol
