Re: [GENERAL] Import Problem

2015-09-16 Thread Venkata Balaji N
On Thu, Sep 17, 2015 at 1:27 AM, Ramesh T wrote: > Hi All, >I'm using or2pg tool ,I exported data but I have to change the > schema import to postgres database.exported data more than gb. > Can you please let me know, how to do the change the name in data script..? > Do you mean that

Re: [GENERAL] BDR problem

2015-09-16 Thread Florin Andrei
On 2015-09-14 13:32, Martín Marqués wrote: We (well, actually mostly you ;)) have pushed 0.9.2 bdr packages in rpm and deb format. $ rpm -qa | grep bdr94-bdr postgresql-bdr94-bdr-debuginfo-0.9.2-1_2ndQuadrant.el7.centos.x86_64 postgresql-bdr94-bdr-0.9.2-1_2ndQuadrant.el7.centos.x86_64 Yup, I'

Re: [GENERAL] BDR: cannot drop database even after parting the node

2015-09-16 Thread Florin Andrei
With all nodes parted from the group, I've tried to remove the bdr extension, or the table I've used for tests, but neither works: bdrdemo=# DROP EXTENSION bdr; ERROR: No peer nodes or peer node count unknown, cannot acquire DDL lock HINT: BDR is probably still starting up, wait a while bdr

[GENERAL] BDR: cannot drop database even after parting the node

2015-09-16 Thread Florin Andrei
postgres=# SELECT bdr.bdr_version(); bdr_version --- 0.9.2-2015-07-24- (1 row) I've tested BDR with one database on two nodes and it worked well. I've created the group on node1 like this: SELECT bdr.bdr_group_create( local_node_name := 'node1', node_external_

Re: [GENERAL] Import Problem

2015-09-16 Thread Rob Sargent
On 09/16/2015 09:27 AM, Ramesh T wrote: Hi All, I'm using or2pg tool ,I exported data but I have to change the schema import to postgres database.exported data more than gb. Can you please let me know, how to do the change the name in data script..? sed is your friend, if you have a

[GENERAL] Import Problem

2015-09-16 Thread Ramesh T
Hi All, I'm using or2pg tool ,I exported data but I have to change the schema import to postgres database.exported data more than gb. Can you please let me know, how to do the change the name in data script..?

Re: [GENERAL] pgpass (in)flexibility

2015-09-16 Thread Jim Nasby
On 9/15/15 10:32 AM, Ben Chobot wrote: On Sep 15, 2015, at 12:27 AM, Jim Nasby wrote: On 9/15/15 12:48 AM, Ben Chobot wrote: We're in a situation where we would like to take advantage of the pgpass hostname field to determine which password gets used. For example: psql -h prod-server -d foo