Re: [ADMIN] error during PITR

2011-12-23 Thread Karuna Karpe
E" from archive 2011-12-23 11:44:18 ISTFATAL: WAL ends before consistent recovery point 2011-12-23 11:44:18 ISTLOG: startup process (PID 4435) exited with exit code 1 2011-12-23 11:44:18 ISTLOG: terminating any other active server processes Can please any one give me solution for that as

[ADMIN] error during PITR

2011-12-22 Thread Karuna Karpe
d transaction was at log time 2011-12-22 07:26:51.427245+05:30 FATAL: requested recovery stop point is before consistent recovery point LOG: startup process (PID 5413) exited with exit code 1 Please let me know what is going wrong in that? can any one please give me solution for this problem??? Regards, Karuna Karpe.

[ADMIN] tablespace backup and recovery from or to remote machine

2011-12-15 Thread Karuna Karpe
7;../pg_tblspc/16387' to '/opt/PostgresPlus/tablespace1' dynamicaly? and Is it possible that we define exiting tablespace location at the time of restore database on another server? Please give me solution for that. Thank You. Regards, Karuna Karpe.

[ADMIN] backup non-built-in tablespace

2011-12-01 Thread Karuna Karpe
can any one let me know that, how to get non-built-in tablespace backup? Thank You. Regards, Karuna Karpe.

[ADMIN] Point in time recovery

2011-11-23 Thread Karuna Karpe
Hello, Can any one please explain me how to use PITR? Regards, karuna karpe.

[ADMIN] Data encrytion and decryption

2011-11-19 Thread Karuna Karpe
Hello, Can any one please explain me that How to use pgp_pub_encrypt, pgp_pub_encrypt_bytea, pgp_pub_decrypt, pgp_pub_decrypt_bytea with example? Regards, Karuna karpe.

Re: [ADMIN] error log, tablespace, wal files

2011-11-10 Thread Karuna Karpe
Thanks to all for giving solution. On Fri, Nov 11, 2011 at 8:24 AM, Craig Ringer wrote: > On 11/10/2011 02:29 PM, Karuna Karpe wrote: > > 1) what is tablespace in postgres? >> > > It's a way of putting some tables, indexes, etc into a different part of > you

[ADMIN] error while loading data into table

2011-11-10 Thread Karuna Karpe
011-11-10 18:46 16863 -rw--- 1 enterprisedb enterprisedb 185901056 2011-11-10 18:46 16863.1 -rw--- 1 enterprisedb enterprisedb 327680 2011-11-10 18:46 16863_fsm what's wrong in above. why not able to connect to database?? Can any please give me solution for that problem Regards, Karuna karpe.

[ADMIN] error log, tablespace, wal files

2011-11-09 Thread Karuna Karpe
oints. Regards, Karuna karpe.

Re: [ADMIN] streaming replication

2011-11-02 Thread Karuna Karpe
50MB data into old master database server Please give me solution for that... Regards, Karuna karpe. On Tue, Nov 1, 2011 at 5:14 PM, Vinay wrote: > Dear Karuna, > > Its one way replication streaming ie Master to Slave. Once failed master > DB is up, you need to rec

[ADMIN] streaming replication

2011-11-01 Thread Karuna Karpe
replicate that additional changes into my failed master server? can any one tell me that how to do this? Regards, karuna karpe.

[ADMIN] user management and edbldr use

2011-10-24 Thread Karuna Karpe
Hello, I am create one linux user that "dba" with password "password". I create one database user "dba_user" with password "dba_user". I add entry into pg_ident.conf MAPNAME SYSTEM-USERNAME PG-USERNAME dba_map dba dba_user I want to connect dba us

[ADMIN] flashback concept in postgres

2011-10-13 Thread Karuna Karpe
Hello, can any one tell me that, oracle flashback similar concept in postgresql? and same like oracle SQL Loader in postgresql. Regards, karuna karpe.

[ADMIN] Some Postgresql Concepts

2011-10-06 Thread Karuna Karpe
Hello, Can any one please tell me the following postgresql concepts? 1. Flashback fundamental 2. Compression, encryption and decryption 3. DB Link and Heterogeneous Concept 4. Storage Management Regards, karuna karpe.

[ADMIN] pgpool

2011-09-23 Thread Karuna Karpe
se give me solution for that? Regards, karuna karpe.

[ADMIN] slony with pgpool

2011-09-22 Thread Karuna Karpe
Hello, please let me know how to use slony replication using pgpool. Regards, karuna karpe.

[ADMIN] slony replication

2011-09-18 Thread Karuna Karpe
? Regards, karuna karpe.

[ADMIN] oracle to postgres migration

2011-09-10 Thread Karuna Karpe
Hello, Please I want to know how to use 'MERGE INTO' statement in oracle database to postgresql, while migrating oracle to postgresql. Please give me solution. Regards, Karuna karpe.

[ADMIN] create schedule job

2011-08-30 Thread Karuna Karpe
dbs in dbs array and backup each one for db in ${dbs[@]} do $PGBIN/pg_dump -i -h $PGHOST -U $PGUSER -F c -b -v -f $BACKUPDIR/$db-$thedate.compressed $db done But this is not create backup file. So please give a solution for that. Regards, karuna karpe.

[ADMIN] help in postgresql

2011-08-19 Thread Karuna Karpe
postgresql? and so on. So, please Can you explain me the difference between oracle and postgres? How the postgresql is beneficial then oracle and other databases? Please help me to being familiar with postgresql. Regards, karuna karpe.