Re: [GENERAL] Xlogdump compiling error : undefined reference to `ber_sockbuf_io_udp'

2014-02-13 Thread Michael Paquier
On Fri, Feb 14, 2014 at 3:14 PM, Adarsh Sharma wrote: > Yes. Able to retrieve table names now. > > I am reviewing the xlogdump output. Is dere any way where i can understand > what is the meaning of these keywords in it. > > [root@1002 tmp]# xlogdump pg_xlog/* > fullanalysis.txt > [root@1002 tmp]#

Re: [GENERAL] Xlogdump compiling error : undefined reference to `ber_sockbuf_io_udp'

2014-02-13 Thread Adarsh Sharma
Yes. Able to retrieve table names now. I am reviewing the xlogdump output. Is dere any way where i can understand what is the meaning of these keywords in it. [root@1002 tmp]# xlogdump pg_xlog/* > fullanalysis.txt [root@1002 tmp]# cat fullanaysis.txt | awk '{print $7}' | sort | uniq XLP_BKP_REM

[GENERAL] Restore postgresql data directory to tablespace on new host? Or swap tablespaces?

2014-02-13 Thread Antman, Jason (CMG-Atlanta)
I have a bunch of test/development databases which we currently refresh with production data as-needed using a NetApp filer's snapshot capabilities - we have a production slave with its datadir on a filer mount (NFS), and once a night (via cron) we shutdown the slave, snapshot the filer volume,

Re: [GENERAL] Can not upgrade from 9.1 to 9.2 or 9.3, --HELP

2014-02-13 Thread Adrian Klaver
On 02/13/2014 04:57 AM, bobspero wrote: I went through postgres website since yesterday and can not upgrade my postgresql from 9.1 to anything greater. At first I did pgupgrade and was told to install postgres-xc, when I installed it, it removed 9.1 and I could not log into it. What/who told yo

Re: [GENERAL] Can not upgrade from 9.1 to 9.2 or 9.3, --HELP

2014-02-13 Thread David Johnston
bobspero wrote > I went through postgres website since yesterday and can not upgrade my > postgresql from 9.1 to anything greater. At first I did pgupgrade and was > told to install postgres-xc, when I installed it, it removed 9.1 and I > could not log into it. I was able to recover it and when I t

Re: [GENERAL] Xlogdump compiling error : undefined reference to `ber_sockbuf_io_udp'

2014-02-13 Thread Alvaro Herrera
Adarsh Sharma escribió: > [cur:1835/26FAFEF8, xid:471303469, rmid:11(Btree), len/tot_len:18/5754, > info:8, prev:1835/26FAFEB0] insert_leaf: s/d/r:1663/1228184/1363155 tid > 28366/20 > Is dere any document where i can co-relate this tid with relations/indexes > in the database. I tried but not

[GENERAL]

2014-02-13 Thread Brahim SABIRI
Hi During installation of installation of postgresql9.3.2 on red hat 5.5 64bits, I have the problem with C compiler : *configure: error: in '/root/postgresql-9.3.2':configure: error: C compiler cannot create executables* are these versions are compliant (red hat 5.5 64bits and postgresql9.3.2)

[GENERAL] Can not upgrade from 9.1 to 9.2 or 9.3, --HELP

2014-02-13 Thread bobspero
I went through postgres website since yesterday and can not upgrade my postgresql from 9.1 to anything greater. At first I did pgupgrade and was told to install postgres-xc, when I installed it, it removed 9.1 and I could not log into it. I was able to recover it and when I the steps from https://w

Re: [GENERAL] Fwd: postgresql & redhat

2014-02-13 Thread Devrim GÜNDÜZ
Hi, On Tue, 2014-02-11 at 21:07 +, Brahim SABIRI wrote: > During installation of installation of postgresql9.3.2 on red hat 5.5 > 64bits, I have the problem with C compiler : > > *configure: error: in '/root/postgresql-9.3.2':* > *configure: error: C compiler cannot create executables* > >

[GENERAL] Fwd: postgresql & redhat

2014-02-13 Thread Brahim SABIRI
-- Forwarded message -- From: Brahim SABIRI Date: 2014-02-11 0:51 GMT+00:00 Subject: postgresql & redhat To: pgsql-bog...@postgresql.org Hi During installation of installation of postgresql9.3.2 on red hat 5.5 64bits, I have the problem with C compiler : *configure: error: in