[GENERAL] How to configure pgsql in such a way that it is always recoverable?

2010-11-03 Thread RP Khare
Hi, I migrated a MySQL database to pgsql 9.0.1. I have never used pgsql before and therefore want to learn all the possible ways to keep the database up and running. Following are my queries: If pgsql service fails to start or due to any reason pgsql database is not connecting, how to restart

[GENERAL] Dealing with locking on batch updates.

2010-11-02 Thread RP Khare
Hi, Though the following issue we are facing at present with Oracle 10g database, but I just want to know how PostgreSQL would solve this problem. We are planning a migration to any open-source RDBMS in future, so just wanted to clear this issue. Let me clear the scenario, the real-life issue

[GENERAL] Enable automatic scheduled backups

2010-10-30 Thread RP Khare
I want pgsql to take automatic scheduled backup of the database every 30 minutes. How to do this?

[GENERAL] Which variant to choose?

2010-10-29 Thread RP Khare
I want to use PostgreSQL for my standalone .NET Windows application. I downloaded PostgreSQL Advanced Server from EnterpriseDB's website and it is very smooth. The GUI also very good. But I suspect how along EnterpriseDB will support it. The second option is to download from p

[GENERAL] Enabling all backup options

2010-06-28 Thread RP Khare
I installed EnterpriseDB PostgreSQL Plus Standard Server R2 and I want to enable each and every feature related to recovery. I want to enable WAL and other features so that at the time of disaster, my database recovery is guaranteed. How to proceed? Regards, Rohit Prakash.

[GENERAL] Migrating from MySQL

2010-06-26 Thread RP Khare
I want to migrate a production MySQL database to PostgreSQL. Is there any free tool that works effectively? I downloaded PostgreSQL plus advanced server from EnterpriseDB website. Should I go with the original community PGSQL edition or EnterpriseDB edition? Regards, Rohit Prakash

[GENERAL] EDB editions

2010-06-26 Thread RP Khare
Hi, What is the difference between PGSQL provided by www.postgresql.org and www.enterprisedb.com? EnterpriseDB offers three variants: Simple PostgreSQLStandard Server, andAdvanced Server I want to migrate my production MySQL database to PostgreSQL. If I go for EnterpriseDB editions,

[GENERAL] Backup issues

2010-06-25 Thread RP Khare
I never used PostgreSQL in production environment. Now I got an opportunity to migrate a MySQL production database to PostgreSQL. Before migrating, I have few queries on data recovery: Is there any feature of scheduled backups?In case there is no backup and I want to shift my data files to a n