Re: [GENERAL] Osx stopping to install

2014-10-24 Thread Adrian Klaver
On 10/24/2014 07:14 AM, TigerNassau wrote: Trying to remove enterprisedb version and install menubar 9.3.5.2. - dragged old app to trash, unzipped new, dragged to app folder and menubar. Won't run since server still running. So did ps aux | grep postgres then sudo kill -3 all the pids Cannot

Re: [GENERAL] dblink password required

2014-10-24 Thread Adrian Klaver
On 10/24/2014 09:30 AM, Oliver Kohll - Mailing Lists wrote: Hi, I’m trying to use dblink to connect from database1 to database2 on the same machine. The Postgres version is 9.3.5. Firstly, I’ve created a user to use with the connection, while logged in as the postgres superuser to database2:

Re: [GENERAL] Finding date intersections

2014-10-24 Thread Joe Van Dyk
On Fri, Oct 24, 2014 at 11:02 AM, David G Johnston < david.g.johns...@gmail.com> wrote: > John McKown wrote > >> insert into sales values > >> (tstzrange('2014-1-1', '2014-1-2')), > >> (tstzrange('2014-1-2', '2014-1-3')), > >> (tstzrange('2014-1-2', '2014-1-4')), > >> (tstzrange('2014-1-5'

Re: [GENERAL] Finding date intersections

2014-10-24 Thread David G Johnston
John McKown wrote >> insert into sales values >> (tstzrange('2014-1-1', '2014-1-2')), >> (tstzrange('2014-1-2', '2014-1-3')), >> (tstzrange('2014-1-2', '2014-1-4')), >> (tstzrange('2014-1-5', '2014-1-6')); >> >> -- want back: >> -- tstzrange('2014-1-1', '2014-1-4') >> -- tstzrange('2014

[GENERAL] dblink password required

2014-10-24 Thread Oliver Kohll - Mailing Lists
Hi, I’m trying to use dblink to connect from database1 to database2 on the same machine. The Postgres version is 9.3.5. Firstly, I’ve created a user to use with the connection, while logged in as the postgres superuser to database2: > create user db_link with password ‘mypassword’; > grant sel

Re: [GENERAL] Emulating flexible regex replace

2014-10-24 Thread twoflower
Thank you Francisco. In fact, I am already solving part of the problem in my application - fetching from the DB the records matching the source pattern and then filtering them in the application's memory by matching against the target pattern, with the references replaced (it's a breeze in C#). I

Re: [GENERAL] Emulating flexible regex replace

2014-10-24 Thread Francisco Olarte
Hi: On Fri, Oct 24, 2014 at 8:24 AM, twoflower wrote: > Thank you Francisco, that's a clever idea. However, I don't think this > would > reduce the complexity since the target pattern can contain > > 1) regular back-references (referencing to matches of its own) > 2) the special source text refe

Re: [GENERAL] Finding date intersections

2014-10-24 Thread John McKown
On Thu, Oct 23, 2014 at 9:10 PM, Joe Van Dyk wrote: > I have a table of sales that have possibly overlapping time ranges. I want > to find all the timeranges where there's an active sale. How would you do > that? > > create table sales ( > times tstzrange > ); > > insert into sales values > (

[GENERAL] Osx stopping to install

2014-10-24 Thread TigerNassau
Trying to remove enterprisedb version and install menubar 9.3.5.2. - dragged old app to trash, unzipped new, dragged to app folder and menubar. Won't run since server still running. So did ps aux | grep postgres then sudo kill -3 all the pids Cannot kill work process - only process remaining N

Re: [GENERAL] is there a warm standby sync trigger?

2014-10-24 Thread Michael Paquier
On Fri, Oct 24, 2014 at 12:30 AM, John Smith wrote: > > i want to setup a warm standby that listens 24/7 but only syncs when > told to (ie only when i am ok with the database updates, will i > trigger the sync). > can i? > > i don't want to manually backup and restore like i do now. That's what p

Re: [GENERAL] ARMv5

2014-10-24 Thread Michael Paquier
On Mon, Oct 20, 2014 at 12:47 PM, Александр Глухов wrote: > Hello, I have a problem with PostgreSQL. I need to install PostgreSQL on > ARMv5 with tcp/ip access, but I have no experience in it. It seems, that > first I must do cross-compilation for ARMv5. Can you help me, or advise > something? Ma

Re: [GENERAL] Log-shipping replication in one machine

2014-10-24 Thread Michael Paquier
On Tue, Oct 21, 2014 at 4:02 PM, nurul [via PostgreSQL] wrote: > > We have install PostgreSQL 9.3 in Ubuntu. We want to ask it is possible to do > log shipping replication in one machine with different port such as port 5435 > as a master while 5436 as a slave? We also tried that process in one

Re: [GENERAL] Log-shipping replication in one machine

2014-10-24 Thread John R Pierce
On 10/21/2014 12:02 AM, nurul [via PostgreSQL] wrote: We do the log shipping replication process based on http://www.themagicnumber.es/replication-in-postgresql-i?lang=en thats a rather old blog entry, appears to be talking about postgres 8.3 -- john r pierce

[GENERAL] Log-shipping replication in one machine

2014-10-24 Thread nurul [via PostgreSQL]
We have install PostgreSQL 9.3 in Ubuntu. We want to ask it is posibble to do log shipping replication in one machine with different port such as port 5435 as a master while 5436 as a slave? We also tried that process in one machine but still get an error in slave such as warning: connection to th

[GENERAL] ARMv5

2014-10-24 Thread Александр Глухов
Hello, I have a problem with PostgreSQL. I need to install PostgreSQL on ARMv5 with tcp/ip access, but I have no experience in it. It seems, that first I must do cross-compilation for ARMv5. Can you help me, or advise something? Maybe you have any guides how to install PostgreSQL on ARM? With