Re: [GENERAL] Public facing PostgreSQL hosting ?

2015-08-31 Thread Maciek Sakrejda
If I understand correctly, you're looking for Postgres hosted as a service? Heroku provides hosting as a service [1], and we do allow you to connect from anywhere. It's true that generally folks in the Postgres community prefer to run databases with perimeter security and only leave your database d

Re: [GENERAL] BDR setup - bdr_node_join_wait_for_ready()

2015-08-31 Thread Craig Ringer
On 28 August 2015 at 00:35, cchee-ob wrote: > What exactly does bdr_node_wait_for_ready() do? I've been trying to setup > BDR on an existing database and once I run the select > bdr.bdr_node_wait_for_ready(); command on the 2nd node after running the > bdr.bdr_group_join() command it just hangs .

Re: [GENERAL] Public facing PostgreSQL hosting ?

2015-08-31 Thread Gavin Flower
On 31/08/15 19:03, essam Ganadily wrote: hi i do develop on PostgreSQL from home and from work. i need public facing PostgreSQL , something i can use Pgadmin from anywhere. performance and scalability is not important because i will be running like few operations per day. any idea where can i

[GENERAL] Postgresql path for json array

2015-08-31 Thread Saravanakumar Murugesan
I have a json for country Table column: countryJson Sample Json : [ { name:india, population: 1000M, type: country, children: [ { name: karnataga, population: 30M, type:state,

Re: [GENERAL] bdr download

2015-08-31 Thread Tom Lane
Bruce Momjian writes: > On Mon, Aug 31, 2015 at 09:58:36AM -0700, Joshua Drake wrote: >> On 08/31/2015 09:37 AM, Bruce Momjian wrote: >>> Huh, why did we decide that when the community doesn't control any of >>> it? That doesn't make any sense. >> It was decided during initial development becaus

Re: [GENERAL] bdr download

2015-08-31 Thread Bruce Momjian
On Mon, Aug 31, 2015 at 04:30:33PM -0300, Alvaro Herrera wrote: > The whole thing is intended to be integrated to upstream Postgres. I > can't believe you haven't seen the following pieces being committed: > > - logical decoding > - replication slots > - replication origin identifier > - commit t

Re: [GENERAL] bdr download

2015-08-31 Thread Alvaro Herrera
Bruce Momjian wrote: > Yeah, I just read the thread. I guess with the low volume makes sense > to use "general", but I figured if someone went to the work of > developing a website for BDR, they would just as soon create a mailing > list hosted there, but I guess not. Actually, that website was

Re: [GENERAL] bdr download

2015-08-31 Thread Joshua D. Drake
On 08/31/2015 12:14 PM, Bruce Momjian wrote: On Mon, Aug 31, 2015 at 09:58:36AM -0700, Joshua Drake wrote: On 08/31/2015 09:37 AM, Bruce Momjian wrote: On Mon, Aug 31, 2015 at 12:30:52PM -0300, Alvaro Herrera wrote: It clearly is being developed by 2nd Quadrant: http://bdr-project.o

Re: [GENERAL] bdr download

2015-08-31 Thread Bruce Momjian
On Mon, Aug 31, 2015 at 09:58:36AM -0700, Joshua Drake wrote: > On 08/31/2015 09:37 AM, Bruce Momjian wrote: > >On Mon, Aug 31, 2015 at 12:30:52PM -0300, Alvaro Herrera wrote: > >>>BDR is not currently part of community Postgres so you will need to > >>>report it to them directly. > >> > >>As discu

Re: [GENERAL] bdr download

2015-08-31 Thread Andres Freund
On 2015-08-31 18:41:19 +0200, Andres Freund wrote: > http://archives.postgresql.org/message-id/%2053A2AA64.9040709%402ndquadrant.com http://archives.postgresql.org/message-id/53A2AA64.9040709%402ndquadrant.com There was a space too much in the link... Greetings, Andres Freund -- Sent via pgs

Re: [GENERAL] bdr download

2015-08-31 Thread Joshua D. Drake
On 08/31/2015 09:37 AM, Bruce Momjian wrote: On Mon, Aug 31, 2015 at 12:30:52PM -0300, Alvaro Herrera wrote: BDR is not currently part of community Postgres so you will need to report it to them directly. As discussed a year ago or so, this list is what to use for BDR reports and discussions,

Re: [GENERAL] bdr download

2015-08-31 Thread Andres Freund
On 2015-08-31 12:37:11 -0400, Bruce Momjian wrote: > On Mon, Aug 31, 2015 at 12:30:52PM -0300, Alvaro Herrera wrote: > > > BDR is not currently part of community Postgres so you will need to > > > report it to them directly. > > > > As discussed a year ago or so, this list is what to use for BDR r

Re: [GENERAL] bdr download

2015-08-31 Thread Bruce Momjian
On Mon, Aug 31, 2015 at 12:30:52PM -0300, Alvaro Herrera wrote: > > BDR is not currently part of community Postgres so you will need to > > report it to them directly. > > As discussed a year ago or so, this list is what to use for BDR reports > and discussions, so this report is in the right plac

Re: [GENERAL] BDR setup - bdr_node_join_wait_for_ready()

2015-08-31 Thread Sylvain MARECHAL
Hello all, Le 31/08/2015 02:25, Martín Marqués a écrit : BTW, why don't you the physical join procedure with bdr_init_copy to join nodes? Are there known problems in the SQL interface ? Thank you, Sylvain -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Public facing PostgreSQL hosting ?

2015-08-31 Thread Steve Crawford
On Mon, Aug 31, 2015 at 12:03 AM, essam Ganadily wrote: > hi > i do develop on PostgreSQL from home and from work. i need public facing > PostgreSQL , something i can use Pgadmin from anywhere. > performance and scalability is not important because i will be running > like few operations per day.

Re: [GENERAL] bdr download

2015-08-31 Thread Alvaro Herrera
Bruce Momjian wrote: > On Mon, Aug 31, 2015 at 10:24:26AM -0400, Ray Stell wrote: > > Two comments on the BDR docs: > > > > The second option provided here, http://bdr-project.org/docs/stable/ > > installation-source.html#INSTALLATION-SOURCE-PREREQS > > "3.3.2.2 Downloading release source tarballs

Re: [GENERAL] bdr download

2015-08-31 Thread Bruce Momjian
On Mon, Aug 31, 2015 at 10:24:26AM -0400, Ray Stell wrote: > Two comments on the BDR docs: > > The second option provided here, http://bdr-project.org/docs/stable/ > installation-source.html#INSTALLATION-SOURCE-PREREQS > "3.3.2.2 Downloading release source tarballs," seems to be an endless loop >

[GENERAL] bdr download

2015-08-31 Thread Ray Stell
Two comments on the BDR docs: The second option provided here, http://bdr-project.org/docs/stable/installation-source.html#INSTALLATION-SOURCE-PREREQS "3.3.2.2 Downloading release source tarballs," seems to be an endless loop between http://bdr-project.org/ and http://2ndquadrant.com/en/resour

Re: [GENERAL] Slave promotion problem...

2015-08-31 Thread marin
On 2015-08-31 14:38, Martín Marqués wrote: El 31/08/15 a las 03:29, ma...@kset.org escribió: Last week we had some problems on the master server which caused a failover on the slave (the master was completely unresponsive due to reasons still unknown). The slave received the promote signal (pg_c

Re: [GENERAL] PostgreSQL Developer Best Practices

2015-08-31 Thread Melvin Davidson
Thank you to all that contributed to this thread. I now have about a dozen guidelines I would like to share. However, since a few individuals felt it was more of an opportunity to prove or disprove certain theories, rather than just contribute additional good practices, I will not be posting them d

Re: [GENERAL] Slave promotion problem...

2015-08-31 Thread Martín Marqués
El 31/08/15 a las 03:29, ma...@kset.org escribió: > Last week we had some problems on the master server which caused a > failover on the slave (the master was completely unresponsive due to > reasons still unknown). The slave received the promote signal (pg_ctl > promote) and logged that in the log

[GENERAL] FW: JsonArray value criteria

2015-08-31 Thread Saravanakumar Murugesan
I have a json for country Table column: countryJson Sample Json : [ { name:india, population: 1000M, type: country, children: [ { name: karnataga, population: 30M, type:state,

Re: [GENERAL] Public facing PostgreSQL hosting ?

2015-08-31 Thread Charles Clavadetscher
Hello You can use pgAdmin (or psql for that matter) to connect to a database over the network, provided PostgreSQL is configured to accept this kind of connections and all the firewalls to it allow the traffic. http://www.postgresql.org/docs/9.4/interactive/runtime-config-connection.html http:/

[GENERAL] Public facing PostgreSQL hosting ?

2015-08-31 Thread essam Ganadily
hi i do develop on PostgreSQL from home and from work. i need public facing PostgreSQL , something i can use Pgadmin from anywhere. performance and scalability is not important because i will be running like few operations per day. any idea where can i find that ? thankx