Re: [ADMIN] hot backup

On Wed, 3 Aug 2005, Steulet Grégory wrote: I just would like to know if it's possible to dot hot backup(not dump) with postgres. That probably depends what you define as a hot backup. Likely what you are looking for is Point in Time Recovery through WAL archiving. Read about it here: http

Re: [ADMIN] Blocking connection and timeout problem

Assuming you are on a linux box (Not sure if it's stated in your mail, sorry if I miss that) you could set /proc/sys/net/ipv4/tcp_keepalive_time to a lower value. That should do the trick :-) Hope it helps. Greetings Dario. On Wed, 2005-08-03 at 16:48 +0200, KÖPFERL Robert wrote: > > > >

[ADMIN] Hello

Hello Sir, I am using PostGreSql ,I want an oledb provider for the postgre in order to connect through.net to a postgre Database, I installed the pgoledb.dll and I registered it and in the connection string I am using the “Provider=PostgreSQL.1 . . .   ,but the following error is occurring

[ADMIN] Instalations problems

I’m from Huajuapan de León, Oaxaca, México. I try to install Postgres in my PC, but the installation was truncated and now a can’t install or uninstall the software, when I try to install appears that the user is wrong, that is already and user and i can’t process the installation. If I loo

[ADMIN] Data integrity check when bad sectors occur

Is there a way to run a check in PostgreSQL to validate each of the records when there is bad records or etc? ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[ADMIN] hot backup

Hi,   I just would like to know if it's possible to dot hot backup(not dump) with postgres.   Thank you   Greg     Grégory SteuletAssistant HES    HEG Haute école de gestion ArcLaboratoire de Base de Données84, rue de l

[ADMIN] Questions about fsync

In the context of PostgreSQL 7.4, running over Linux Suse 9.0, I have some doubts that wanted to evacuate: In which processes impacts the property fsync? Which can be the problem to use fsync in false? When use fsync = false, the effective recording of the data in disk is done for criteria of th

Re: [ADMIN] Question on placing database on a network attached storage

N/A wrote: Hi, I'm putting together a mission critical application which will use a Postgresql database, and I am trying to decide if I should place my Postgresql database on a network attached storage appliance or on local disks. Wherever possible, I think that local storage is almost al

[ADMIN] Postgres and Tomcat combined installation on Windows

Does anyone have experience of doing a combined installation of Postgres and Tomcat in one single installation on Windows based platforms. By doing a single installion along with an application packaged as a war file, things would be really simplified. ---(end of bro

Re: [ADMIN] Vacuum doesn't end

strace did show what looked like it was stuck waiting, and it was the same vacuum proc as in the pg_Stat_activity. I had to restart the postmaster and eventually reload the data because no subsequent vacuum would finish properly. Was there anything else I could have done? On that note, if I am j

[ADMIN] Questions about fsync

In the context of PostgreSQL 7.4, running over Linux Suse 9.0, I have some doubts that wanted to evacuate: In which processes impacts the property fsync? Which can be the problem to use fsync in false? When use fsync = false, the effective recording of the data in disk is done for criteria of t