Re: [ADMIN] Clarification when using Continous Archiving in 8.4

2013-08-09 Thread Bruce Momjian
On Fri, Aug 9, 2013 at 10:20:13AM +0200, Jan Lentfer wrote: > On Thu, 8 Aug 2013 21:36:35 -0400, Bruce Momjian wrote: > > On Tue, Jul 16, 2013 at 11:30:54AM -0500, Nestor A. Diaz wrote: > > Hello People, In reference to my last post , my question is: It is > possible to recov

Re: [ADMIN] Request for help

2013-08-09 Thread Jan Lentfer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Am 09.08.2013 21:49, schrieb ramana...@gmail.com: > We have recently converted our db2 database to PostgreSQL and we > stuck on one thing I,e Authentication of users. > > Let me explain what was in DB2, > > We have a unix group "mhubrpt" on DB2 unix

Re: [ADMIN] Request for help

2013-08-09 Thread Shivakumar Ramannavar
Hi, Even I am new but I think we need to configure in pga-hba config file as below: http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html Thanks! Shiva On Sat, Aug 10, 2013 at 1:19 AM, wrote: > > Hi, > > We have recently converted our db2 database to PostgreSQL and we stuck on > on

[ADMIN] Request for help

2013-08-09 Thread ramanajvv
Hi, We have recently converted our db2 database to PostgreSQL and we stuck on one thing I,e Authentication of users. Let me explain what was in DB2, We have a unix group "mhubrpt" on DB2 unix server and have connect permissions to DB2 database for that group. Whenever user needs access to DB

[ADMIN] PostgreSQL don't start

2013-08-09 Thread Lilian BENOIT
Hi, I have a problem with my postgresql instance. I don't start service. My server had stopped abrupt because a fs was full . It have a only partition. I think that a postgresql clog file is corrupt. I used RPMs for install PostgreSQL with default repository postgresql-8.4.13-1.el6_3.i686 postgre

Re: [ADMIN] Only WAL archive left. Need to restore data.

2013-08-09 Thread bricklen
On Fri, Aug 9, 2013 at 4:06 AM, Sergey Arlashin < sergeyarl.maill...@gmail.com> wrote: > Hi, > I have 2GB backup of WAL archive folder but the backup of postgres database > cluster directory is lost. > However I need to restore any data possible from these WAL logs. > > Is that possible? What do I

Re: [ADMIN] Only WAL archive left. Need to restore data.

2013-08-09 Thread Albe Laurenz
Sergey Arlashin wrote: > I have 2GB backup of WAL archive folder but the backup of postgres database > cluster directory is lost. > However I need to restore any data possible from these WAL logs. > > Is that possible? What do I do to get the data. Unfortunately that is impossible. Yours, Laure

[ADMIN] Only WAL archive left. Need to restore data.

2013-08-09 Thread Sergey Arlashin
Hi, I have 2GB backup of WAL archive folder but the backup of postgres database cluster directory is lost. However I need to restore any data possible from these WAL logs. Is that possible? What do I do to get the data. Thanks in advance. -- Best regards, Sergey Arlashin

Re: [ADMIN] Clarification when using Continous Archiving in 8.4

2013-08-09 Thread Jan Lentfer
On Thu, 8 Aug 2013 21:36:35 -0400, Bruce Momjian wrote: > On Tue, Jul 16, 2013 at 11:30:54AM -0500, Nestor A. Diaz wrote: > >> Hello People, In reference to my last post , my question is: It is possible to recover more (subsequent) WAL files when I have already recover a postgres 8.4 databas

Re: [ADMIN] After upgrading from 9.1.1 to 9.1.9, pgadmin's server status window gives error

2013-08-09 Thread Albe Laurenz
Brian Wong wrote: -- An error has occurred: ERROR: could not access file "$libdir/adminpack": No such file or directory -- > I'm on Oracle Enterprise Linux. >