[GENERAL] postgresql service is working but showing status failed

2016-10-03 Thread devangn
Everything looks and works as it should, just i am not getting the status opensips service as active (running) instead i am getting active (exited), what am i missing here? # netstat -pan|grep 5432 tcp0 0 0.0.0.0:54320.0.0.0:* LISTEN 589/postgres # /etc

[GENERAL] Make psql print number values right-aligned with locale group separator?

2016-10-03 Thread David G. Johnston
Take this as either a request for a pointer to how to accomplish $subject or a feature request. psql nicely prints number values right-aligned - but otherwise applies only a single decimal separator. Using to_char() to get the proper formatting is annoying and has downsides as well (mixing presen

Re: [GENERAL] isnull() function in pgAdmin3

2016-10-03 Thread David G. Johnston
On Mon, Oct 3, 2016 at 6:39 AM, dudedoe01 wrote: > What is the most feasible way to emulate the below MySQL function into > postgreSQL. Since the isnull() function is no longer supported in 9.6 > version. I have tried every trick in the hat to get the desired results. > Still 'RPG INV' doesn't sh

[GENERAL] Re: [GENERAL] Understanding “max_wal_size” and “min_wal_size” parameters default values from postgresql.conf file

2016-10-03 Thread otar shavadze
Thank you very much On Mon, Oct 3, 2016 at 11:46 PM, Tom Lane wrote: > otar shavadze writes: > > name | setting | unit-- > > max_wal_size | 64 | > > min_wal_size | 5| > > > I have 2 questions: > > > 1) Why these values doesn't match default

Re: [GENERAL] isnull() function in pgAdmin3

2016-10-03 Thread Raymond O'Donnell
On 03/10/16 14:39, dudedoe01 wrote: What is the most feasible way to emulate the below MySQL function into postgreSQL. Since the isnull() function is no longer supported in 9.6 version. I have tried every trick in the hat to get the desired results. Still 'RPG INV' doesn't show only the other two

Re: [GENERAL] isnull() function in pgAdmin3

2016-10-03 Thread Adrian Klaver
On 10/03/2016 06:39 AM, dudedoe01 wrote: What is the most feasible way to emulate the below MySQL function into postgreSQL. Since the isnull() function is no longer supported in 9.6 One more time, Postgres does not have an isnull() function in any version AFAIK. You need to use IS NULL: http

Re: [GENERAL] isnull() function in pgAdmin3

2016-10-03 Thread Ken Tanzer
On Mon, Oct 3, 2016 at 6:39 AM, dudedoe01 wrote: > What is the most feasible way to emulate the below MySQL function into > postgreSQL. Since the isnull() function is no longer supported in 9.6 > version. I have tried every trick in the hat to get the desired results. > Still 'RPG INV' doesn't sh

Re: [GENERAL] Problems with pg_upgrade after change of unix user running db.

2016-10-03 Thread Tom Lane
Benedikt Grundmann writes: > proddb_testing=# SELECT > conname,convalidated,conislocal,coninhcount,connoinherit > proddb_testing-# FROM pg_constraint WHERE conrelid = > 'js_activity_20110101'::regclass; >conname | convalidated | conislocal | > coninhcount | co

Re: [GENERAL] Understanding “max_wal_size” and “min_wal_size” parameters default values from postgresql.conf file

2016-10-03 Thread Tom Lane
otar shavadze writes: > name | setting | unit-- > max_wal_size | 64 | > min_wal_size | 5| > I have 2 questions: > 1) Why these values doesn't match default values, which are shown in docs? > I never changed config settings at all. They do m

[GENERAL] Understanding “max_wal_size” and “min_wal_size” parameters default values from postgresql.conf file

2016-10-03 Thread otar shavadze
According to documentation, for "min_wal_size" and "max_wal_size" parameters default values are: For max_wal_size: The default is 1 GB For min_wal_size: The default is 80 MB Then I look this parameters from my database config:

[GENERAL] Installing pgAdmin 4 in Oracle Enterprise Linux 7

2016-10-03 Thread Edson Richter
Dear community, I'm trying to install pgAdmin4 in Oracle EL 7. I've already installed PostgreSQL 9.6 final in same server (have EPEL enabled, as well pgdg 9.6 repos). Running "yum install pgadmin4-web" I get the following result: "[root@backup1 yum.repos.d]# LANG=C yum install pgadmin4-web

Re: [GENERAL] isnull() function in pgAdmin3

2016-10-03 Thread dudedoe01
What is the most feasible way to emulate the below MySQL function into postgreSQL. Since the isnull() function is no longer supported in 9.6 version. I have tried every trick in the hat to get the desired results. Still 'RPG INV' doesn't show only the other two then options show up. (case

[GENERAL]

2016-10-03 Thread otar shavadze
n6gSVg

Re: [GENERAL] ZSON, PostgreSQL extension for compressing JSONB

2016-10-03 Thread Alan Gano
I like this, seeing that the keys of JSON docs are replicated in every record. I makes my old-school DBA-Sense start to itch. On Fri, Sep 30, 2016 at 8:58 AM, Aleksander Alekseev < a.aleks...@postgrespro.ru> wrote: > Hello. > > I've just uploaded ZSON extension on GitHub: > > https://github.co

Re: [GENERAL] Installing pgAdmin 4 in Oracle Enterprise Linux 7

2016-10-03 Thread Edson Richter
On 03/10/2016 10:12, Devrim Gündüz wrote: > Hi Edson, > > On Mon, 2016-10-03 at 00:18 +, Edson Richter wrote: >> https://download.postgresql.org/pub/repos/yum/testing/9.6/redhat/rhel-7Server >> -x86_64/repodata/repomd.xml: >> [Errno 14] HTTPS Error 404 - Not Found >> Trying other mirror. > Fixe

Re: [GENERAL] Problems with pg_upgrade after change of unix user running db.

2016-10-03 Thread Benedikt Grundmann
On 3 October 2016 at 15:54, Tom Lane wrote: > Benedikt Grundmann writes: > > And it looks like now I'm back to the error that stopped me last time: > > pg_restore: [archiver (db)] Error from TOC entry 8425; 2606 416548282 > CHECK > > CONSTRAINT seqno_not_null postgres_prod > > pg_restore: [archi

Re: [GENERAL] Problems with pg_upgrade after change of unix user running db.

2016-10-03 Thread Tom Lane
Benedikt Grundmann writes: > And it looks like now I'm back to the error that stopped me last time: > pg_restore: [archiver (db)] Error from TOC entry 8425; 2606 416548282 CHECK > CONSTRAINT seqno_not_null postgres_prod > pg_restore: [archiver (db)] could not execute query: ERROR: constraint > "s

Re: [GENERAL] Problems with pg_upgrade after change of unix user running db.

2016-10-03 Thread Benedikt Grundmann
On 3 October 2016 at 15:30, Tom Lane wrote: > Benedikt Grundmann writes: > > On 3 October 2016 at 14:12, Tom Lane wrote: > >> You're going to need to manually drop that operator from the source > >> database, as "=>" isn't a legal operator name anymore. This appears > >> to be left over from a

Re: [GENERAL] Problems with pg_upgrade after change of unix user running db.

2016-10-03 Thread Tom Lane
Benedikt Grundmann writes: > On 3 October 2016 at 14:12, Tom Lane wrote: >> You're going to need to manually drop that operator from the source >> database, as "=>" isn't a legal operator name anymore. This appears >> to be left over from a pre-9.0 version of hstore. > Thanks for the quick repl

Re: [GENERAL] Problems with pg_upgrade after change of unix user running db.

2016-10-03 Thread Benedikt Grundmann
On 3 October 2016 at 14:12, Tom Lane wrote: > Benedikt Grundmann writes: > > I just tried this again. This time from 9.2.17 to 9.5.4 and pg_upgrade > > chokes with this: > > > > [root@igm-dbc-001 upgrade-logs]# tail pg_upgrade_dump_16416.log > > pg_restore: [archiver (db)] could not execute que

Re: [GENERAL] [ANNOUNCE] pgAdmin 4 v1.0 Released!

2016-10-03 Thread Adrian Klaver
On 10/03/2016 02:27 AM, Tim Clarke wrote: On 01/10/16 01:43, Adrian Klaver wrote: Before you run the python setup.py part you will then have to install a lot of Flask dependencies: Flask-Babel==0.11.1 Flask-Gravatar==0.4.2 Flask-Login==0.3.2 Flask-Mail==0.9.1 Flask-Principal==0.4.0 Flask-Secu

Re: [GENERAL] Problems with pg_upgrade after change of unix user running db.

2016-10-03 Thread Tom Lane
Benedikt Grundmann writes: > I just tried this again. This time from 9.2.17 to 9.5.4 and pg_upgrade > chokes with this: > > [root@igm-dbc-001 upgrade-logs]# tail pg_upgrade_dump_16416.log > pg_restore: [archiver (db)] could not execute query: ERROR: syntax error > at or near "=>" > LINE 1: CREA

Re: [GENERAL] Installing pgAdmin 4 in Oracle Enterprise Linux 7

2016-10-03 Thread Devrim Gündüz
Hi Edson, On Mon, 2016-10-03 at 00:18 +, Edson Richter wrote: > https://download.postgresql.org/pub/repos/yum/testing/9.6/redhat/rhel-7Server > -x86_64/repodata/repomd.xml:  > [Errno 14] HTTPS Error 404 - Not Found > Trying other mirror. Fixed this error, sorry for that. > > > >> Error: Pac

Re: [GENERAL] Problems with pg_upgrade after change of unix user running db.

2016-10-03 Thread Benedikt Grundmann
On 30 November 2015 at 17:01, Bruce Momjian wrote: > On Mon, Nov 30, 2015 at 04:51:15PM +, Benedikt Grundmann wrote: > > Are you able to compile from 9.4 git head and test that? It seems > > dumping inheriting constraints from parents has not worked properly > for > > some time.

Re: [GENERAL] [ANNOUNCE] pgAdmin 4 v1.0 Released!

2016-10-03 Thread Tim Clarke
On 01/10/16 01:43, Adrian Klaver wrote: > > Before you run the python setup.py part you will then have to install > a lot of Flask dependencies: > > Flask-Babel==0.11.1 > Flask-Gravatar==0.4.2 > Flask-Login==0.3.2 > Flask-Mail==0.9.1 > Flask-Principal==0.4.0 > Flask-Security==1.7.5 > Flask-SQLAlch

Re: [GENERAL] [ANNOUNCE] pgAdmin 4 v1.0 Released!

2016-10-03 Thread Tim Clarke
On 30/09/16 21:24, Adrian Klaver wrote: > > What happens if you move the pgAdmin4 runtime outside the build > environment and run it? I receive the message "Failed to locate pgAdmin4.py, terminating server thread." > > Can you import Flask in a Python interpreter? Yes, that works fine. > > Do y