On 04/10/2015 12:34 PM, Volkan Unsal wrote:
Hi Adrian,
I think there are some commands that are being run in single user mode,
which is why we are seeing these lines in the output.
https://gist.github.com/volkanunsal/1778cf691223e77f2e30#file-master-log-L57-L58
But I believe the server itself
Hi, folks!
I've a async master to slave database replication, both 9.3.5 running
Oracle Linux 7 x64.
Today, a intermitent link that ended with abrupt interruption, and made
necessary to promote the slave database to master.
After promotion, two medium databases (<5Gb) became active without
iss
Hi Adrian,
I see nowhere in your init-master.sh where Postgres is restarted.
Yes, you're right. The base image takes care of that –– the base image of
mdillon/postgis is postgres:9.3. See here, for instance:
https://github.com/docker-library/postgres/blob/master/9.3/docker-entrypoint.sh#L70
On 04/10/2015 01:06 PM, Volkan Unsal wrote:
Hi Adrian,
I see nowhere in your init-master.sh where Postgres is restarted.
Yes, you're right. The base image takes care of that –– the base image
of mdillon/postgis is postgres:9.3. See here, for instance:
https://github.com/docker-library/p
Hi Adrian,
I spent the last hour checking the config files are indeed being used ––
and they are. :P I'm getting silly after days of this configuration
nightmare. Thanks for replying to all my posts and making helpful
suggestions. After reading a bit more about log outputs, I enabled the
maximum l
On 04/10/2015 02:10 PM, Volkan Unsal wrote:
Hi Adrian,
I spent the last hour checking the config files are indeed being used ––
and they are. :P I'm getting silly after days of this configuration
nightmare. Thanks for replying to all my posts and making helpful
suggestions. After reading a bit m
On 04/10/2015 02:10 PM, Volkan Unsal wrote:
Hi Adrian,
I spent the last hour checking the config files are indeed being used ––
and they are. :P I'm getting silly after days of this configuration
nightmare. Thanks for replying to all my posts and making helpful
suggestions. After reading a bit m
> Please, what does:
>
> select * from pg_stat_replication
>
> show on the primary?
>
It shows 0 rows.
Here is the pg_xlog folder from standby:
root@cba9f6ba3f6e:/# cat ${PGDATA}/pg_xlog/
> 0001000C archive_status
And here it is from the primary:
>
> root@ad4a83bdcf9e:/#
On 04/10/2015 03:47 PM, Volkan Unsal wrote:
Please, what does:
select * from pg_stat_replication
show on the primary?
It shows 0 rows.
Are sure there is only one instance of Postgres running on the primary
container?
What does ps ax | grep post show?
Is the primary databa
Hello all,
I hope someone will can help me.
When I use pgr_kdijkstrapath function as this:
select * FROM pgr_kdijkstrapath('
SELECT d.id,
source::integer,
target::integer,
c.cost::double precision as cost
Hello all,
I hope someone will can help me.
When I use pgr_kdijkstrapath function as this:
select * FROM pgr_kdijkstrapath('
SELECT d.id,
source::integer,
target::integer,
c.cost::double precision as cost
On Thursday, April 9, 2015, Marc-André Goderre wrote:
> Hello all,
> I hope someone will can help me.
>
> Then, where's the difference between the result of (select
> array_agg(end_id::integer)::integer[] as id from n2) AND '{28411,25582}'
>
There isn't...though technically the former is an int
On Sat, Apr 11, 2015 at 12:57 AM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Fri, Apr 10, 2015 at 9:01 AM, Sameer Kumar
> wrote:
>
>> Hi,
>>
>> In PostgreSQL a user can alter itself to change its user level
>> parameters. e.g. I can alter the user to change work_mem -
>>
>>
>> psq
13 matches
Mail list logo
