Re: [GENERAL] PostgreSQL 9.5, mysql_fdw, and IMPORT FOREIGN SCHEMA question

OK, that did it! I submitted 2 PRs to the EnterpriseDB/mysql_fdw GitHub project which should resolve all outstanding issues for me. https://github.com/EnterpriseDB/mysql_fdw/pull/81 https://github.com/EnterpriseDB/mysql_fdw/pull/82 Isn't it great when Open Source works like it's supposed to!!!

Re: [GENERAL] PostgreSQL 9.5, mysql_fdw, and IMPORT FOREIGN SCHEMA question

I think that I may have found the problem. It looks like the mysql_fdw uses the following query to gather information about the foreign schema: SELECT t.TABLE_NAME, c.COLUMN_NAME, CASE WHEN c.DATA_TYPE = 'enum' THEN LOWER(CONCAT(c.COLUMN_NAME, '_t')) WHEN c.DATA_TYPE = 'tinyint' THEN 'sma

Re: [GENERAL] PostgreSQL 9.5, mysql_fdw, and IMPORT FOREIGN SCHEMA question

Additional details. The MySQL server I am targeting is running version 5.1.73. Perhaps it's too old of a version to support foreign schema import? Deven On Fri, Jan 8, 2016 at 11:45 PM, Deven Phillips wrote: > I DID get a foreign table to work using the following: > > CREATE FOREIGN TABLE custo

Re: [GENERAL] PostgreSQL 9.5, mysql_fdw, and IMPORT FOREIGN SCHEMA question

I DID get a foreign table to work using the following: CREATE FOREIGN TABLE customer ( id BIGINT, name VARCHAR(150), parent_id BIGINT, oracle_id BIGINT, last_updated_time TIMESTAMP, created_time TIMESTAMP) SERVER mysql OPTIONS (dbname 'mydb', table_name 'customer'); And I was subsequently able to

Re: [GENERAL] PostgreSQL 9.5, mysql_fdw, and IMPORT FOREIGN SCHEMA question

Apparently not, though I have done so in the past on PostgreSQL 9.4. It appears to be related to the "schema" with which the foreign table is associated: mydb=# CREATE FOREIGN TABLE customer ( id BIGINT, name VARCHAR(150), parent_id BIGINT, oracle_id BIGINT, last_updated_time TIMESTAMP, created_ti

Re: [GENERAL] PostgreSQL 9.5, mysql_fdw, and IMPORT FOREIGN SCHEMA question

On 01/08/2016 07:04 AM, Deven Phillips wrote: Hi all, I installed the newly released PostgreSQL 9.5 this morning and compiled the latest mysql_fdw extension from EnterpriseDB. I was able to create the SERVER and USER MAPPING, but I cannot seem to get IMPORT FOREIGN SCHEMA to do anything. Th

[GENERAL] PostgreSQL 9.5, mysql_fdw, and IMPORT FOREIGN SCHEMA question

Hi all, I installed the newly released PostgreSQL 9.5 this morning and compiled the latest mysql_fdw extension from EnterpriseDB. I was able to create the SERVER and USER MAPPING, but I cannot seem to get IMPORT FOREIGN SCHEMA to do anything. The command executes without error, but none of the

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

On 1/7/2016 12:41 PM, balajishanmu...@live.in wrote: For storage I am using a 2.5inch SATA 3 SSD hard disk. It is about 60 GB. I am yet to get the log. I will post the Postgres log once I have it. is this an enterprise grade SSD with supercap backup? or is it a consumer desktop/notebook class

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

On Thu, Jan 7, 2016 at 1:41 PM, balajishanmu...@live.in wrote: > Hi, > > For storage I am using a 2.5inch SATA 3 SSD hard disk. It is about 60 GB. I > am yet to get the log. I will post the Postgres log once I have it. > > Thanks! Yeah a lot of cheaper consumer grade SSDs don't fsync safely. Ther

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

Hi, For storage I am using a 2.5inch SATA 3 SSD hard disk. It is about 60 GB. I am yet to get the log. I will post the Postgres log once I have it. Thanks! -- View this message in context: http://postgresql.nabble.com/Postgresql-9-3-not-coming-up-after-restart-in-centos-tp5880435p5880957.htm

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

On Wed, Jan 6, 2016 at 2:08 PM, balajishanmu...@live.in wrote: > Most of the time I will be restarting centOS by issuing reboot command. Which > will do the orderly shutdown of all the service and sometimes just pull the > plug. > > But the issue appears to be random. Is there a way that before Po

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

On 01/06/2016 01:08 PM, balajishanmu...@live.in wrote: Most of the time I will be restarting centOS by issuing reboot command. Which will do the orderly shutdown of all the service and sometimes just pull the plug. But the issue appears to be random. Is there a way that before Postgres starts we

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

Most of the time I will be restarting centOS by issuing reboot command. Which will do the orderly shutdown of all the service and sometimes just pull the plug. But the issue appears to be random. Is there a way that before Postgres starts we can check whether data is flushed, if not flush it manua

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

On Wed, Jan 6, 2016 at 12:36 PM, balajishanmu...@live.in wrote: > By application I mean centOS. > > We are starting and stopping Postgres using systemd service. We have a > service file called postgresql9.3.service which is used to start or stop > Postgres. > > Excerpts of postgresql9.3.service >

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

By application I mean centOS. We are starting and stopping Postgres using systemd service. We have a service file called postgresql9.3.service which is used to start or stop Postgres. Excerpts of postgresql9.3.service ExecStartPre=/usr/pgsql-9.3/bin/postgresql93-check-db-dir ${PGDATA} ExecStart=

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

On 01/05/2016 11:18 AM, balajishanmu...@live.in wrote: Hi I have installed postgresql-9.3 in my centos application. When the application starts for first-time Postgres starts without any issue most of Not sure what you are talking about when you say CentOS application. Are you saying when Cen

[GENERAL] Postgresql 9.3 not coming up after restart in centos

Hi I have installed postgresql-9.3 in my centos application. When the application starts for first-time Postgres starts without any issue most of the time. But when I reboot the centOs, Postgres is not getting started on subsequent boot and I am getting the error, LOG: invalid magic number

Re: [GENERAL] PostgreSQL GUI tools

On Sun, 2016-01-03 at 03:15 -0700, subhan alimy wrote: > Hello everyone, > > Is there any PostgreSQL GUI tools to pull the tables structure along > with > the relationships? > > > Much appropriated.   > > If you are a Java shop you can use ExecuteQuery from www.executequery.o rg You need to

Re: [GENERAL] PostgreSQL GUI tools

Thank you very much. -- View this message in context: http://postgresql.nabble.com/PostgreSQL-GUI-tools-tp5879926p5880036.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] PostgreSQL GUI tools

I recently tried many tools, and "sql power architect" is the tool I have selected. It is compatible with liquibase, and works with postgres, mysql oracle and so on. It allows comparing structure differences between databases. Moreover it has a community free edition that covers my needs. 2016-01-

Re: [GENERAL] PostgreSQL GUI tools

On Sun, Jan 3, 2016 at 2:15 AM, subhan alimy wrote: > Is there any PostgreSQL GUI tools to pull the tables structure along with > the relationships? > Along with the other suggestions, I have personally used http://www.dbschema.com/. It works well, but I don't recall if there was a free version.

Re: [GENERAL] PostgreSQL GUI tools

On 01/03/2016 02:15 AM, subhan alimy wrote: Hello everyone, Is there any PostgreSQL GUI tools to pull the tables structure along with the relationships? A simple Google will show you that there are literally dozens. Much appropriated. -- View this message in context: http://postgresql.

Re: [GENERAL] PostgreSQL GUI tools

Here is the list of tools: https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools#pgEdit On Sun, Jan 3, 2016 at 3:45 PM, subhan alimy wrote: > Hello everyone, > > Is there any PostgreSQL GUI tools to pull the tables structure along with > the relationships? > > > Much appropri

[GENERAL] PostgreSQL GUI tools

Hello everyone, Is there any PostgreSQL GUI tools to pull the tables structure along with the relationships? Much appropriated. -- View this message in context: http://postgresql.nabble.com/PostgreSQL-GUI-tools-tp5879926.html Sent from the PostgreSQL - general mailing list archive at Nabbl

Re: [GENERAL] - PostgreSQL Replication Types

On 12/17/2015 08:43 AM, Will McCormick wrote: Almost forgot this: SELECT pg_current_xlog_location(); I was not paying attention earlier that should be: pg_last_xlog_receive_location() from: http://www.postgresql.org/docs/9.1/interactive/functions-admin.html Table 9-58. Recovery I

Re: [GENERAL] - PostgreSQL Replication Types

Almost forgot this: SELECT pg_current_xlog_location(); ERROR: recovery is in progress HINT: WAL control functions cannot be executed during recovery. bms=> SELECT pg_current_xlog_location(); ERROR: recovery is in progress HINT: WAL control functions cannot be executed during recovery.

Re: [GENERAL] - PostgreSQL Replication Types

On 12/17/2015 07:56 AM, Will McCormick wrote: Thanks a ton for the prompt response. I've read most of this but some it was not clear until we discussed. See here for more detail: WLM: Reading now :) While reading I would suggest having the postgres.conf files on the master and the stan

Re: [GENERAL] - PostgreSQL Replication Types

Thanks for the great assistance On Thu, Dec 17, 2015 at 11:27 AM, Adrian Klaver wrote: > On 12/17/2015 07:56 AM, Will McCormick wrote: > >> Thanks a ton for the prompt response. >> >> I've read most of this but some it was not clear until we discussed. >> >> Updated with WLM: >> >> On 12/17/2015

Re: [GENERAL] - PostgreSQL Replication Types

On 12/17/2015 07:56 AM, Will McCormick wrote: Thanks a ton for the prompt response. I've read most of this but some it was not clear until we discussed. Updated with WLM: On 12/17/2015 07:17 AM, Will McCormick wrote: I inherited a 9.1 replication environment Few basic questions that

Re: [GENERAL] - PostgreSQL Replication Types

Thanks a ton for the prompt response. I've read most of this but some it was not clear until we discussed. Updated with WLM: On 12/17/2015 07:17 AM, Will McCormick wrote: > > I inherited a 9.1 replication environment > > Few basic questions that I can't find clear answers / clarifications for >

Re: [GENERAL] - PostgreSQL Replication Types

Hi Will, On 12/17/15 10:17 AM, Will McCormick wrote: > I inherited a 9.1 replication environment > > Few basic questions that I can't find clear answers / clarifications for > if possible: > > 3 types of replication in 9.1 I've read about from the offical docs: > > 1) warm standby This is a s

Re: [GENERAL] - PostgreSQL Replication Types

On 12/17/2015 07:17 AM, Will McCormick wrote: I inherited a 9.1 replication environment Few basic questions that I can't find clear answers / clarifications for if possible: 3 types of replication in 9.1 I've read about from the offical docs: 1) warm standby 2) hot standby 3) streaming replica

[GENERAL] - PostgreSQL Replication Types

I inherited a 9.1 replication environment Few basic questions that I can't find clear answers / clarifications for if possible: 3 types of replication in 9.1 I've read about from the offical docs: 1) warm standby 2) hot standby 3) streaming replication I'm using streaming replication I believe,

Re: [GENERAL] postgresql 9.3 failover time

On 12/12/15 2:08 PM, Shay Cohavi wrote: > *I have postgresql 9.3 setup with 2 nodes (active/standby with streaming > replication & continuos archiving).* > *I have created 2 failover & failback script in order to perform a > switchover between the DB servers:* > *1. failover - create a trigger file

Re: [GENERAL] Postgresql INET select and default route ?

Fabuous ! Thank you ! On 14 December 2015 at 07:52, Albe Laurenz wrote: > Tim Smith wrote: >> Re: I am surprised that you don't expect "0.0.0.0/0" to be returned by the >> first >> query if you expect it to be returned by the second. >> Is that an oversicht? >> >> Thanks for the question, but n

Re: [GENERAL] Postgresql INET select and default route ?

Tim Smith wrote: > Re: I am surprised that you don't expect "0.0.0.0/0" to be returned by the > first > query if you expect it to be returned by the second. > Is that an oversicht? > > Thanks for the question, but no, it wasn't an oversight, I only am > looking for 0.0.0.0/0 to be returned if the

Re: [GENERAL] Postgresql INET select and default route ?

Hi Albe, Apologies for the delayed reply. Re: I am surprised that you don't expect "0.0.0.0/0" to be returned by the first query if you expect it to be returned by the second. Is that an oversicht? Thanks for the question, but no, it wasn't an oversight, I only am looking for 0.0.0.0/0 to be ret

[GENERAL] postgresql 9.3 failover time

*Hi,* *I have postgresql 9.3 setup with 2 nodes (active/standby with streaming replication & continuos archiving).* *I have created 2 failover & failback script in order to perform a switchover between the DB servers:* *1. failover - create a trigger file in order to promote the new primary.* *2. f

Re: [GENERAL] [PostgreSQL+SOCI+BOOST] Compile error in core\exchange-traits.h with PG and SOCI on Windows

On 12/10/2015 06:55 AM, Lawry, Brian wrote: Hi. This isn’t really a PostgreSQL question but I’ve gotten no response to the following issue posted on the SOCI-users list. I’m posting here in the hope that someone has Did you see this response?: http://comments.gmane.org/gmane.comp.db.soci.us

Re: [GENERAL] [PostgreSQL+SOCI+BOOST] Compile error in core\exchange-traits.h with PG and SOCI on Windows

On 12/10/2015 06:55 AM, Lawry, Brian wrote: Hi. This isn’t really a PostgreSQL question but I’ve gotten no response to the following issue posted on the SOCI-users list. I’m posting here in the hope that someone has experience building SOCI for PostgreSQL with Boost type support on Windows.

Re: [GENERAL] [PostgreSQL+SOCI+BOOST] Compile error in core\exchange-traits.h with PG and SOCI on Windows

"Lawry, Brian" writes: > This isn’t really a PostgreSQL question but I’ve gotten no response to > the following > issue posted on the SOCI-users list. I’m posting here in the hope that > someone has > experience building SOCI for PostgreSQL with Boost type support on Windows. > I can bui

[GENERAL] [PostgreSQL+SOCI+BOOST] Compile error in core\exchange-traits.h with PG and SOCI on Windows

Hi. This isn’t really a PostgreSQL question but I’ve gotten no response to the following issue posted on the SOCI-users list. I’m posting here in the hope that someone has experience building SOCI for PostgreSQL with Boost type support on Windows. Configuration: Using SOCI 3.2.3, Boost

Re: [GENERAL] Postgresql INET select and default route ?

Tim Smith wrote: > create table test(a inet); > insert into test values ('0.0.0.0/0'); > insert into test values ('10.1.2.3'); > => select * from test; > a > --- > 0.0.0.0/0 > 10.1.2.3 > (2 rows) > > > This works as expected . > => select * from test where a <<= '10.1.2.3'; >

[GENERAL] Postgresql INET select and default route ?

Hi, create table test(a inet); insert into test values ('0.0.0.0/0'); insert into test values ('10.1.2.3'); => select * from test; a --- 0.0.0.0/0 10.1.2.3 (2 rows) This works as expected . => select * from test where a <<= '10.1.2.3'; a -- 10.1.2.3 (1 row) This

Re: [GENERAL] Postgresql Dump Question

Sachin Srivastava writes: > Hi Team, > > If anybody have PostgreSQL Dump questions like Oracle dump question for > preparation of PostgreSQL certification. kindly provide, if someone have. Are you just interested in passing the test? If so, then I can't help you. Please read the Pg documentat

[GENERAL] Postgresql Dump Question

Hi Team, If anybody have PostgreSQL Dump questions like Oracle dump question for preparation of PostgreSQL certification. kindly provide, if someone have. Regards, SS

Re: [GENERAL] Postgresql Installation -- Red Hat vs OpenSUSE vs Ubuntu

On 10/28/2015 02:20 PM, Michael Convey wrote: Forgive my ignorance, but I'm new to PostgreSQL. Regarding installation, I'm trying to understand some of the differences between Red Hat, Ubuntu, and OpenSUSE. My goal is to set up a self-contained lab instance for learning on each distribution. So,

Re: [GENERAL] Postgresql SSI: read/write dependencies

On Wednesday, October 28, 2015 4:33 PM, Pavel Suderevsky wrote: > I am working on better insight of postgresql serialization > mechanism. The main question is - how to determine serialization > behaviour at system level and predict exception: > ERROR: could not serialize access due to read/wri

[GENERAL] Postgresql SSI: read/write dependencies

Hi, I am working on better insight of postgresql serialization mechanism. The main question is - how to determine serialization behaviour at system level and predict exception: > ERROR: could not serialize access due to read/write dependencies among > transactions > DETAIL: Reason code: Cancele

[GENERAL] Postgresql Installation -- Red Hat vs OpenSUSE vs Ubuntu

Forgive my ignorance, but I'm new to PostgreSQL. Regarding installation, I'm trying to understand some of the differences between Red Hat, Ubuntu, and OpenSUSE. My goal is to set up a self-contained lab instance for learning on each distribution. So, I assume I'll need both the client and server on

Re: [GENERAL] PostgreSQL Timezone and Brazilian DST

Perfect explanation and indeed useful suggestions. I'll play a bit with a development server. Thanks, Atenciosamente, Edson Carlos Ericksson Richter Em 28/10/2015 12:15, Yves Dorfsman escreveu: On 2015-10-27 20:29, Edson Richter wrote: Hi! Using PostgreSQL 9.3.10 x86_64 Oracle EL7 compiled

Re: [GENERAL] PostgreSQL Timezone and Brazilian DST

Thanks, Tom. I'll play a bit with this in a development server. Regards, Atenciosamente, Edson Carlos Ericksson Richter Em 28/10/2015 12:06, Tom Lane escreveu: Adrian Klaver writes: No, if the above does not indicate a problem, then the issue is probably, as Francisco said, in the timezone

Re: [GENERAL] PostgreSQL Timezone and Brazilian DST

On 2015-10-27 20:29, Edson Richter wrote: > Hi! > > Using PostgreSQL 9.3.10 x86_64 Oracle EL7 compiled by gcc (GCC) 4.8.3 > 20140911, installed using yum repository. > > In postgresql.conf, I do have: > > timezone="America/Sao_Paulo" > > Since DST is in place in Brazil, it is enough to "systemc

Re: [GENERAL] PostgreSQL Timezone and Brazilian DST

Adrian Klaver writes: > No, if the above does not indicate a problem, then the issue is > probably, as Francisco said, in the timezone definitions. The thing is, > you are on 9.3.10 which has the latest time zone data file: Since OEL is a naked ripoff of Red Hat, I would assume that they config

Re: [GENERAL] PostgreSQL Timezone and Brazilian DST

On 10/27/2015 10:43 PM, Edson Richter wrote: Adrian Klaver escreveu > On 10/27/2015 07:29 PM, Edson Richter wrote: > > Hi! > > > > Using PostgreSQL 9.3.10 x86_64 Oracle EL7 compiled by gcc (GCC) 4.8.3 > > 20140911, installed using yum repository. > > > > In postgresql.conf, I do

Re: [GENERAL] PostgreSQL Timezone and Brazilian DST

On Wed, Oct 28, 2015 at 6:43 AM, Edson Richter wrote: > Configured since first setup. Brazil went DST few days ago. > Today, executing > Select now() > Resulted in > > 2015-10-28 02:45:37-03:00 > > I do expect > > 2015-10-28 03:45:37-02:00 > > I suspect that Postgres is ignoring the DST change.

Re: [GENERAL] PostgreSQL Timezone and Brazilian DST

Adrian Klaver escreveu > On 10/27/2015 07:29 PM, Edson Richter wrote: > > Hi! > > > > Using PostgreSQL 9.3.10 x86_64 Oracle EL7 compiled by gcc (GCC) 4.8.3 > > 20140911, installed using yum repository. > > > > In postgresql.conf, I do have: > > > > timezone="America/Sao_Paulo" > > > >

Re: [GENERAL] PostgreSQL Timezone and Brazilian DST

On 10/27/2015 07:29 PM, Edson Richter wrote: Hi! Using PostgreSQL 9.3.10 x86_64 Oracle EL7 compiled by gcc (GCC) 4.8.3 20140911, installed using yum repository. In postgresql.conf, I do have: timezone="America/Sao_Paulo" Since DST is in place in Brazil, it is enough to "systemctl reload postg

[GENERAL] PostgreSQL Timezone and Brazilian DST

Hi! Using PostgreSQL 9.3.10 x86_64 Oracle EL7 compiled by gcc (GCC) 4.8.3 20140911, installed using yum repository. In postgresql.conf, I do have: timezone="America/Sao_Paulo" Since DST is in place in Brazil, it is enough to "systemctl reload postgresql-9.3" to make it effective? Or a comp

Re: [GENERAL] postgresql 9.4 streaming replication

WAL sender process starts when streaming client is active. The connection is initiated by the client. That's why you cannot see it. It also uses the TCP-port that is used by any other pg client. There is a special entry in the pg_hba.conf for the replication clients. Refer to this please: http://ww

Re: [GENERAL] postgresql 9.4 streaming replication

On 2015-10-19 08:34:51 +, Sven Löschner wrote: > My client recovery.conf looks this way: > > standby_mode = 'on' > primary_conninfo = 'host=arcserver1 port=5432 user=postgres pass=postgres' > restore_command = 'pg_standby /db/pg_archived %f %p >> /var/log/standby.log' > primary_slot_name='stan

Re: [GENERAL] postgresql 9.4 streaming replication

On 19 October 2015 at 09:41, Sven Löschner wrote: > I inserted the following in my pg_hba.conf to test, but it does not work: > > hostreplication rep_user0.0.0.0/0 trust > hostall postgres0.0.0.0/0 trust > > thank you in advan

Re: [GENERAL] postgresql 9.4 streaming replication

I inserted the following in my pg_hba.conf to test, but it does not work: hostreplication rep_user0.0.0.0/0 trust hostall postgres0.0.0.0/0 trust thank you in advance, Sven WAL sender process starts when streaming client i

Re: [GENERAL] postgresql 9.4 streaming replication

My client recovery.conf looks this way: standby_mode = 'on' primary_conninfo = 'host=arcserver1 port=5432 user=postgres pass=postgres' restore_command = 'pg_standby /db/pg_archived %f %p >> /var/log/standby.log' primary_slot_name='standby1' Zitat von Andreas Kretschmer : Do you have a client

Re: [GENERAL] postgresql 9.4 streaming replication

Do you have a client with a propper recovery.conf running? Am 19. Oktober 2015 09:58:40 MESZ, schrieb "Sven Löschner" : >I have the following problem: i am trying to set up a streaming >replication scenario with load balancing. I read various tutorials but > >i cannot find the mistake. The repl

[GENERAL] postgresql 9.4 streaming replication

I have the following problem: i am trying to set up a streaming replication scenario with load balancing. I read various tutorials but i cannot find the mistake. The replication does not work. I do not have a "wal sender/receiver process". The archiving works and everytime the master restar

Re: [GENERAL] postgresql doesn't start

On 10/04/2015 02:45 AM, Paolo De Michele wrote: Adrian, thanks a lot about your questions 1. postgresql was installed via apt-get install postgresql -y command 2. in /var/run/postgresql/ there is only one file called 9.3-main.pid 3. postgres is not running, I did not find nothing with ps comman

Re: [GENERAL] postgresql doesn't start

On 10/04/2015 02:45 AM, Paolo De Michele wrote: Adrian, thanks a lot about your questions 1. postgresql was installed via apt-get install postgresql -y command What OS and version? 2. in /var/run/postgresql/ there is only one file called 9.3-main.pid 3. postgres is not running, I did not fi

Re: [GENERAL] postgresql doesn't start

Adrian, thanks a lot about your questions 1. postgresql was installed via apt-get install postgresql -y command 2. in /var/run/postgresql/ there is only one file called 9.3-main.pid 3. postgres is not running, I did not find nothing with ps command 4. I remove the postmaster.pid file and I tried

Re: [GENERAL] postgresql doesn't start

On 10/03/2015 05:50 AM, Paolo De Michele wrote: hi there, thanks a lot so, I'm using docker on ubuntu 14.04 about permissions: # ls -la /var/lib/postgresql/9.3/main total 72 drwx-- 28 postgres postgres 4096 Oct 3 12:41 . drwxr-xr-x 4 postgres postgres 4096 Oct 1 11:59 .. -rwx-- 1 po

Re: [GENERAL] postgresql doesn't start

hi there, thanks a lot so, I'm using docker on ubuntu 14.04 about permissions: # ls -la /var/lib/postgresql/9.3/main total 72 drwx-- 28 postgres postgres 4096 Oct 3 12:41 . drwxr-xr-x 4 postgres postgres 4096 Oct 1 11:59 .. -rwx-- 1 postgres postgres4 Mar 21 2015 PG_VERSION drwx-

Re: [GENERAL] postgresql doesn't start

​Are you using docker on centos ? I had problem with centos/docker/postgresql because container size was (maybe still is) limited to 20GB on that specific OS​. Maybe not related, but good to know 2015-10-03 0:03 GMT+02:00 John R Pierce : > On 10/2/2015 2:02 PM, Paolo De Michele wrote: > >> exec s

Re: [GENERAL] postgresql doesn't start

On 10/2/2015 2:02 PM, Paolo De Michele wrote: exec su postgres -c "/usr/lib/postgresql/9.3/bin/postgres -D /var/lib/postgresql/9.3/main -c config_file=/etc/postgresql/9.3/main/postgresql.conf" until yesterday there were no problem right now I see this in the /var/log/supervisor's directory: 2

Re: [GENERAL] postgresql doesn't start

On 10/02/2015 02:02 PM, Paolo De Michele wrote: hi there, I've a big problem with my postgresql installation I've postgresql 9.3 installed on docker; I start it via supervisord I've never had issues with postgresql and I don't touched nothing (no update, no changes) this is my configuration the

Re: [GENERAL] postgresql doesn't start

On 10/2/2015 2:02 PM, Paolo De Michele wrote: I've postgresql 9.3 installed on docker docker is a packaging system for linux containers, its not an operating system per se.what OS is your docker container running on? supervisord is a process/daemon manager, its not part of 'postgresql

Re: [GENERAL] postgresql doesn't start

Paolo De Michele writes: > 2015-10-01 21:40:20 UTC FATAL: could not remove old lock file > "postmaster.pid": Permission denied Looks like something removed the postmaster's write permission on the data directory itself. regards, tom lane -- Sent via pgsql-general mail

[GENERAL] postgresql doesn't start

hi there, I've a big problem with my postgresql installation I've postgresql 9.3 installed on docker; I start it via supervisord I've never had issues with postgresql and I don't touched nothing (no update, no changes) this is my configuration there's a file called postgresql.conf in /etc/supervi

Re: [GENERAL] Postgresql 9.4 and ZFS?

On 10/1/15 8:04 PM, Joseph Kregloh wrote: In either case you are still "bottlenecked" by the speed of the write from RAM to the zpool. Now for a small database with not many writes a ZIL would be awesome. But on a write heavy database you will be acknowledging more writes because of the ZIL that

Re: [GENERAL] Postgresql 9.4 and ZFS?

On Thu, Oct 1, 2015 at 5:51 PM, Jim Nasby wrote: > On 10/1/15 8:50 AM, Joseph Kregloh wrote: > >> In my testing with pgbench I actually saw a decrease in performance with >> a ZIL enabled. I ended up just keeping the L2ARC and dropping the. ZIL >> will not provide you with any speed boost as a da

Re: [GENERAL] Postgresql 9.4 and ZFS?

On 10/1/15 8:50 AM, Joseph Kregloh wrote: In my testing with pgbench I actually saw a decrease in performance with a ZIL enabled. I ended up just keeping the L2ARC and dropping the. ZIL will not provide you with any speed boost as a database. On a NAS with NFS shared for example, a ZIL would work

Re: [GENERAL] Postgresql 9.4 and ZFS?

On Wed, Sep 30, 2015 at 5:12 PM, Benjamin Smith wrote: > On Wednesday, September 30, 2015 09:58:08 PM Tomas Vondra wrote: > > On 09/30/2015 07:33 PM, Benjamin Smith wrote: > > > On Wednesday, September 30, 2015 02:22:31 PM Tomas Vondra wrote: > > >> I think this really depends on the workload - i

Re: [GENERAL] Postgresql 9.4 and ZFS?

On Wed, Sep 30, 2015 at 4:58 PM, Benjamin Smith wrote: > On Wednesday, September 30, 2015 03:49:44 PM Keith Fiske wrote: > > We've run postgres on ZFS for years with great success (first on > > OpenSolaris, now on OmniOS, and I personally run it on FreeBSD). The > > snapshotting feature makes upg

Re: [GENERAL] Postgresql 9.4 and ZFS?

On Wednesday, September 30, 2015 03:49:44 PM Keith Fiske wrote: > We've run postgres on ZFS for years with great success (first on > OpenSolaris, now on OmniOS, and I personally run it on FreeBSD). The > snapshotting feature makes upgrades on large clusters much less scary > (snapshot and revert if

Re: [GENERAL] Postgresql 9.4 and ZFS?

On Wednesday, September 30, 2015 09:58:08 PM Tomas Vondra wrote: > On 09/30/2015 07:33 PM, Benjamin Smith wrote: > > On Wednesday, September 30, 2015 02:22:31 PM Tomas Vondra wrote: > >> I think this really depends on the workload - if you have a lot of > >> random writes, CoW filesystems will perf

Re: [GENERAL] Postgresql 9.4 and ZFS?

On 09/30/2015 03:45 PM, Patric Bechtel wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Tomas, Tomas Vondra schrieb am 30.09.2015 um 14:01: Hi, ... I've also done a few runs with compression, but that reduces the performance a bit (understandably). I'm somewhat surprised by the

Re: [GENERAL] Postgresql 9.4 and ZFS?

On 09/30/2015 07:33 PM, Benjamin Smith wrote: On Wednesday, September 30, 2015 02:22:31 PM Tomas Vondra wrote: I think this really depends on the workload - if you have a lot of random writes, CoW filesystems will perform significantly worse than e.g. EXT4 or XFS, even on SSD. I'd be curious

Re: [GENERAL] Postgresql 9.4 and ZFS?

On Tue, Sep 29, 2015 at 1:01 PM, Benjamin Smith wrote: > Does anybody here have any recommendations for using PostgreSQL 9.4 > (latest) > with ZFS? > > We've been running both on ZFS/CentOS 6 with excellent results, and are > considering putting the two together. In particular, the CoW nature (an

Re: [GENERAL] Postgresql 9.4 and ZFS?

On Wednesday, September 30, 2015 02:22:31 PM Tomas Vondra wrote: > I think this really depends on the workload - if you have a lot of > random writes, CoW filesystems will perform significantly worse than > e.g. EXT4 or XFS, even on SSD. I'd be curious about the information you have that leads you

Re: [GENERAL] Postgresql 9.4 and ZFS?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Tomas, Tomas Vondra schrieb am 30.09.2015 um 14:01: > Hi, > > On 09/30/2015 12:21 AM, Patric Bechtel wrote: >> -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 >> >> Hi Benjamin, >> >> if you're using compression, forget about that. You need to syn

Re: [GENERAL] Postgresql 9.4 and ZFS?

Hi, On 09/29/2015 07:01 PM, Benjamin Smith wrote: Does anybody here have any recommendations for using PostgreSQL 9.4 (latest)with ZFS? I think this really depends on the workload - if you have a lot of random writes, CoW filesystems will perform significantly worse than e.g. EXT4 or XFS, ev

Re: [GENERAL] Postgresql 9.4 and ZFS?

Hi, On 09/30/2015 12:21 AM, Patric Bechtel wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Benjamin, if you're using compression, forget about that. You need to synchronize the ashift value to the internal rowsize of you SSD, that's it. Make sure your SSD doesn't lie to you regarding w

Re: [GENERAL] Postgresql 9.4 and ZFS?

I use pg with zfs on freebsd,it work great.I test zol 1 years ago,it will crash the os on load. Some note for pg on freebsd from my experience: 1.if you use compression,8k recordsize make the compression ratio poor.I reach 7.x with gzip using default record size(128k if I remember) while get 2.x

Re: [GENERAL] Postgresql 9.4 and ZFS?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Benjamin, if you're using compression, forget about that. You need to synchronize the ashift value to the internal rowsize of you SSD, that's it. Make sure your SSD doesn't lie to you regarding writing blocks and their respective order. In that c

Re: [GENERAL] Postgresql 9.4 and ZFS?

On 9/29/2015 1:08 PM, Benjamin Smith wrote: put pgdata in its own zfs file system in your zpool. on that dedicated >zfs, set the blocksize to 8k. Based on my reading here, that would be -o ashift=13 ? HowDoesZFSonLinuxHandleAdvacedFormatDrives EG: 2^13 = 8192 sorry, I meant recordsize.

Re: [GENERAL] Postgresql 9.4 and ZFS?

On Tue, Sep 29, 2015 at 01:08:20PM -0700, Benjamin Smith wrote: > On Tuesday, September 29, 2015 10:35:28 AM John R Pierce wrote: > > On 9/29/2015 10:01 AM, Benjamin Smith wrote: > > > Does anybody here have any recommendations for using PostgreSQL 9.4 > > > (latest) with ZFS? > > > > For database

Re: [GENERAL] Postgresql 9.4 and ZFS?

On Tuesday, September 29, 2015 10:35:28 AM John R Pierce wrote: > On 9/29/2015 10:01 AM, Benjamin Smith wrote: > > Does anybody here have any recommendations for using PostgreSQL 9.4 > > (latest) with ZFS? > > For databases, I've always used mirrored pools, not raidz*. > put pgdata in its own zf

Re: [GENERAL] Postgresql 9.4 and ZFS?

On 9/29/2015 10:01 AM, Benjamin Smith wrote: Does anybody here have any recommendations for using PostgreSQL 9.4 (latest) with ZFS? For databases, I've always used mirrored pools, not raidz*. put pgdata in its own zfs file system in your zpool. on that dedicated zfs, set the blocksize to 8k.

[GENERAL] Postgresql 9.4 and ZFS?

Does anybody here have any recommendations for using PostgreSQL 9.4 (latest) with ZFS? We've been running both on ZFS/CentOS 6 with excellent results, and are considering putting the two together. In particular, the CoW nature (and subsequent fragmentation/thrashing) of ZFS becomes largely irr

Re: [GENERAL] Postgresql HA questions

Thanks. I'd taken some stabs at setting up Corosync/Pacemaker, but could never get the PostgreSQL portion to work properly. One difficulty is that I am using named replication slots, which don't appear to be supported. The other issue is that the system tended to try to start my secondary as primar

Re: [GENERAL] Postgresql HA questions

Israel, I can't answer all your questions, but we've just set up a HA pair with *Hot Standby using Corosync/Pacemaker*. However we haven't deployed this 'live' yet. We originally found a presentation from The PostgreSQL Conference PostgreSQL High Availability with Corosync/Pacemaker

<    1   2   3   4   5   6   7   8   9   10   >