[ADMIN] Rollback DELETE command using backup + WAL

2007-09-18 Thread Zarko Susnjar
Hello, I'm using PGSQL version 8.0 "Accidentally" I deleted around 4 (it's exactly 44242) rows from one table. Last backup (.sql) I made is 1 month old and probably only around 3 records are there. After deleting records immediately I made a copy of pgsql/data directory and i see that pro

Re: [ADMIN] Postgresql Server is not starting during it's installation

2007-09-18 Thread Scott Marlowe
On 9/18/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hello Sir, > During the installation of "Postgresql Database Server" when I am > tring execute the command "/usr/local/pgsql/bin/postgres -D > /usr/local/pgsql/data" it shows an error message: > LOG: could not translate

[ADMIN] Postgresql Server is not starting during it's installation

2007-09-18 Thread ankur
Hello Sir, During the installation of "Postgresql Database Server" when I am tring execute the command "/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data" it shows an error message: LOG: could not translate host name "localhost", service "5432" to address: Name or service

[ADMIN] Problem installing postgre on windows.

2007-09-18 Thread Elharar, Oded
Hi, This seems to be discussed a lot in forums but I haven't really found a solution to this problem. The problem: 1. We have a customer trying to install our product on his machine (with special configuration, more details below). As part of our product installation, our installer calls the i

[ADMIN] Pista de Auditorias

2007-09-18 Thread Jorge Gabriel Gonzalez
Buenos Días, quisiera consultarles 1. sobre pistas de auditorias en PostgreSQL, si solo la opción log_statement checkeado, ya basta, o hay otra opción? 2. Algún Designer bueno para POSTGRESQL? Saludos -- Jorge Gabriel González B. Analista de Sistemas PROGRESS-Fábrica de Software E-mail ([EMAI