Re: [GENERAL] BDR conpilation error un Ubuntu 12.4 LTS

2014-12-22 Thread stefano bonnin
I have upgraded GCC to: gcc (Ubuntu 4.8.1-2ubuntu1~12.04) 4.8.1 Now the error is: make -C ../../src/interfaces/libpq all make[1]: Entering directory `/usr/src/meteosmit/postgresql-BDR/2ndquadrant_bdr/src/interfaces/libpq' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/usr/sr

Re: [GENERAL] BDR conpilation error un Ubuntu 12.4 LTS

2014-12-22 Thread stefano bonnin
Hi Giuseppe, gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3 a newer version needed? 2014-12-22 14:00 GMT+01:00 Giuseppe Broccolo < giuseppe.brocc...@2ndquadrant.it>: > > Hi Stefano, > > Which version of gcc are you using? > > Giuseppe. > > 2014-12-22 9:52 GMT+01:00 stefano bonnin : > >> >> Hi all, I h

[GENERAL] help troubleshooting invalid page header error

2014-12-22 Thread Cory Zue
Hi all, Our postgres instance on one of our production machines has recently been returning errors of the form "DatabaseError: invalid page header in block 1 of relation base/16384/76623" from normal queries. I've been reading that these are often linked to hardware errors, but I would like to bet

[GENERAL] psql feature request: --list-conninfo (dump the config info psql would use to connect)

2014-12-22 Thread David Johnston
Hi! When psql (libpq) connects it uses a combination of defaults, environment variables, command line arguments, and possibly a pg_service file to figure out where it is going to connect, and how. Specifying the option "--list-conninfo" as an option would cause psql to simply output all of the va

Re: [GENERAL] 9.3.5 failing to compile with dtrace on FreeBSD 10.1

2014-12-22 Thread Lacey Powers
Hello Luca, I had some success getting PostgreSQL 9.4 to build on FreeBSD 10.1-p2 RELEASE with DTrace. The probes look fully functional, and fun to work with, though I haven't had time to get incredibly deep into using them.This is what worked for me, after much digging around. I was buildin

Re: [GENERAL] how to append records from dump to existing database?

2014-12-22 Thread Adrian Klaver
On 12/22/2014 04:16 AM, wetter wetterana wrote: Hi, I would like to know how I could append a database dump to an existing database without clearing it. Example: I got a database 'db' with a tables 't1' including variables 'var1' and 'var2', and table 't2' with variables 'var3' and 'var4'. Earl

Re: [GENERAL] BDR conpilation error un Ubuntu 12.4 LTS

2014-12-22 Thread Giuseppe Broccolo
Hi Stefano, Which version of gcc are you using? Giuseppe. 2014-12-22 9:52 GMT+01:00 stefano bonnin : > > Hi all, I have followed the wiki about postgresql BDR: > > OS: Ubuntu 12.04.5 LTS > > >- git clone git://git.postgresql.org/git/2ndquadrant_bdr.git >- cd 2ndquadrant_bdr >- git c

[GENERAL] how to append records from dump to existing database?

2014-12-22 Thread wetter wetterana
Hi, I would like to know how I could append a database dump to an existing database without clearing it. Example: I got a database 'db' with a tables 't1' including variables 'var1' and 'var2', and table 't2' with variables 'var3' and 'var4'. Earlier this year, I stored records 1 to 100 in this d

[GENERAL] BDR conpilation error un Ubuntu 12.4 LTS

2014-12-22 Thread stefano bonnin
Hi all, I have followed the wiki about postgresql BDR: OS: Ubuntu 12.04.5 LTS - git clone git://git.postgresql.org/git/2ndquadrant_bdr.git - cd 2ndquadrant_bdr - git checkout bdr/0.7.1 - ./configure --prefix=$HOME/bdr --with-openssl - make - make install To install the BDR ext