Re: [GENERAL] initdb with ignore hidden option

), or an employee or agent of the addressee(s), please note that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender of the error. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql

Re: [GENERAL] Logical replication

On 05/01/2017 09:34 AM, Adrian Klaver wrote: > On 05/01/2017 09:25 AM, Peter Eisentraut wrote: >> On 5/1/17 10:32, Adrian Klaver wrote: >>> On 04/30/2017 09:07 AM, Adrian Klaver wrote: >>>> I have started looking at the logical replication feature in Postgres >>

Re: [GENERAL] Column information

On 05/04/2017 07:44 AM, Tom Lane wrote: Adrian Klaver <adrian.kla...@aklaver.com> writes: Alright I see that, but why does my example show a numeric_precision_radix of 10? Is there some transition point where it goes from base 10 to base 2? In PG, "numeric" always has r

Re: [GENERAL] Column information

On 05/04/2017 07:29 AM, Tom Lane wrote: Adrian Klaver <adrian.kla...@aklaver.com> writes: On 05/04/2017 07:00 AM, Tom Lane wrote: No, certainly not. The radix column says what the units of measurement are, not that the values in the precision column aren't decimal. So radix 2 ind

Re: [GENERAL] Column information

On 05/04/2017 07:29 AM, Tom Lane wrote: Adrian Klaver <adrian.kla...@aklaver.com> writes: On 05/04/2017 07:00 AM, Tom Lane wrote: No, certainly not. The radix column says what the units of measurement are, not that the values in the precision column aren't decimal. So radix 2 ind

Re: [GENERAL] Column information

radix. For all other data types, this column is null. " regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Column information

Thank you. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Column rename in an extension update script

psql script works fine, - I reproduce this with all supported postgres versions. As a workaround, I perform the UPDATE statement before the ALTER TABLE operation, using of course the old column name. I probably do something wrong. But I can't see what. Thanks by advance for any piece of advi

Re: [GENERAL] all serial type was changed to 1

software in the mix? There is no application using the database? Regards, Max -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] all serial type was changed to 1

touching this database. Also are you using any third party code? -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] all serial type was changed to 1

violates unique constraint "serial_test_pkey" DETAIL: Key (id)=(1) already exists. Regards, Max -Original Message----- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, 2 May 2017 9:16 AM To: Max Wang <mw...@1080agile.com>; pgsql-general@postgresql.org Subje

Re: [GENERAL] all serial type was changed to 1

1 log_cnt | 0 is_cycled | f is_called | f Can you do that on the serial column from one the affected tables and post the results here? Thanks. Regards, Max -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, 2 May 2017 9:31

Re: [GENERAL] all serial type was changed to 1

Regards, Max -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] all serial type was changed to 1

value or maxvalue, respectively. If NO CYCLE is specified, any calls to nextval after the sequence has reached its maximum value will return an error. If neither CYCLE or NO CYCLE are specified, NO CYCLE is the default. " Regards, Max -- Adrian Klaver adrian.kla...@aklaver.com -

Re: [GENERAL] Logical replication

On 05/01/2017 09:25 AM, Peter Eisentraut wrote: On 5/1/17 10:32, Adrian Klaver wrote: On 04/30/2017 09:07 AM, Adrian Klaver wrote: I have started looking at the logical replication feature in Postgres 10. One thing I have no been able to determine is the interoperability between

Re: [GENERAL] GENERAL : [Can somebody explain about Base directory]

ribed further in Section 65.4. Unlogged tables and indexes have a third fork, known as the initialization fork, which is stored in a fork with the suffix _init (see Section 65.5)." So if it is growing it is because the databases are growing. -- Regards : Venktesh Guttedar. -- Adr

Re: [GENERAL] Logical replication

On 04/30/2017 09:07 AM, Adrian Klaver wrote: I have started looking at the logical replication feature in Postgres 10. One thing I have no been able to determine is the interoperability between it and pglogical(www.2ndquadrant.com/en/resources/pglogical/). I know the one is derived from

Re: [GENERAL] all serial type was changed to 1

. Regards, Max -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Logical replication

a Postgres 9.4 instance with the pglogical extension installed can communicate with a Postgres 10 instance using the built in code? -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] GDAL OUT-DB RASTER SUPPORT

ing about is outside the code the core Postgres community maintains. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PostgreSQL upgrade best practices, please share your thoughts

because someone went from using a self compiled version to one from a package or pulled from different repos. Can you please share what issues you had when upgrading and maybe how you solved it? I'd love to include as much information as possible. Thanks in advance Daniel -- Adrian Klaver

Re: [GENERAL] How to upgrade PostgreSQL minor version?

. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to upgrade PostgreSQL minor version?

, *Sameer Kumar | Senior Solution Architect* *ASHNIK PTE. LTD.* 101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533 T: +65 6438 3504 | www.ashnik.com <http://www.ashnik.com/> Skype: sameer.ashnik | M: +65 8110 0350 -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Failed dependencies for Pgadmin4 Web in Centos 7

On 04/24/2017 07:56 AM, Clodoaldo Neto wrote: On Mon, Apr 24, 2017 at 11:15 AM, Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote: To be clear I am not a Yum/RPM expert. Where is the spec file coming from? From the pgadmin4-v1

Re: [GENERAL] Failed dependencies for Pgadmin4 Web in Centos 7

and use the Wheel: https://www.pgadmin.org/download/pip4.php Clodoaldo -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Failed dependencies for Pgadmin4 Web in Centos 7

On 04/24/2017 05:06 AM, Clodoaldo Neto wrote: Please reply to list also Ccing list On Sun, Apr 23, 2017 at 4:58 PM, Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote: I disabled the priorities plugin and got no excluded packages but still the

Re: [GENERAL] [pgadmin-hackers] file permission on ssl key

r which allows me to configure it how I want it. I'm actually considering settling for the last solution, due to this crazy restriction you put in place... Regards, Jeroen. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql

Re: [GENERAL] Strange Issue between PSQL 9.3 and Label Zebra Printer?

among other things. If that looks alright then check to see if there is a newer driver available. Lastly contact the Zebra tech support to see if they can offer any advice. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Strange Issue between PSQL 9.3 and Label Zebra Printer?

the same issue, correct? Thanks. On Sat, Apr 22, 2017 at 11:28 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: On 04/21/2017 05:14 PM, Periko Support wrote: Hi guys. I would to explain my current strange issue with our label printer -. Windows 8.1 x64, psqlodbc 9.5x86/x64 drivers

Re: [GENERAL] Failed dependencies for Pgadmin4 Web in Centos 7

em You could try running: rpm -Va --nofiles --nodigest Regards, Clodoaldo -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Protocol 2 and query parameters support

://www.postgresql.org/docs/9.6/static/protocol-changes.html -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_basebackup issue

to use postgres user or create a user directly with replication role(Which we are not interested in). In future is there possibility to allow a user(using above steps) to do pg_basebackup?. Thanks, Chiru -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] pg_basebackup issue

want to put the question directly to the developers I would suggest either: 1) Posting to --hackers (https://www.postgresql.org/list/pgsql-hackers/) 2) Filing a bug report: https://www.postgresql.org/account/login/?next=/account/submitbug/ Thanks, Chiru -- Adrian Klaver adrian.kla

Re: [GENERAL] Not sure this should be asked here but...

isplay irony re: "allows to search for other similar issues"?​ ​ https://www.postgresql.org/message-id/CY4PR13MB1751ED37A959456DA0DE115599310%40CY4PR13MB1751.namprd13.prod.outlook.com "browser interface to forums please?" ​David J.

Re: [GENERAL] pg_basebackup issue

n for many years now we have not done so. It seems like reality could be better documented but the present behavior should stay. I also find the original choice to be quite sane regardless. David J. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general

Re: [GENERAL] pg_basebackup issue

2 -U *backup_admin* -x -z --verbose *pg_basebackup: could not connect to server: FATAL: must be superuser or replication role to start walsender* * * On Sat, Apr 22, 2017 at 2:00 PM, Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote: On 04/2

Re: [GENERAL] Strange Issue between PSQL 9.3 and Label Zebra Printer?

14.x PSQL 9.3.x We have other printer from DataMAX which we don't have any issue and the connection is by LAN. So what does it do? Wondering is some one here have in the past issues like this one? Thanks for your time!!! -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql

Re: [GENERAL] pg_basebackup issue

not. Thanks, Chiru -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_basebackup issue

eing work or not works appears to be due to superuser privileges differences. David J. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_basebackup issue

t connect to server: FATAL: must be superuser or replication role to start walsender So I would also be interested in knowing why it does not work? -- john r pierce, recycling bits in santa cruz -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pg

Re: [GENERAL] Recover PostgreSQL database folder data

On 04/21/2017 04:20 PM, Edson Lidorio wrote: On 21-04-2017 18:13, Edson Lidorio wrote: On 21-04-2017 18:02, Adrian Klaver wrote: Chown -R postgres: postgres /var/lib/pgsql/9.6/data After the command, I have the errors: Apr 21 18:11:41 localhost postgresql96-check-db-dir: "/var/lib/

Re: [GENERAL] Recover PostgreSQL database folder data

ve tablespace links. Are those tablespaces actually there? Can you find postgresql96-check-db-dir and see what it is looking for? -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Recover PostgreSQL database folder data

On 04/21/2017 02:13 PM, Edson Lidorio wrote: On 21-04-2017 18:02, Adrian Klaver wrote: Chown -R postgres: postgres /var/lib/pgsql/9.6/data After the command, I have the errors: What does the directory listing for /var/lib/pgsql/9.6/data show? Apr 21 18:11:41 localhost postgresql96-check

Re: [GENERAL] Recover PostgreSQL database folder data

On 04/21/2017 01:53 PM, Edson Lidorio wrote: On 21-04-2017 17:43, Adrian Klaver wrote: On 04/21/2017 01:36 PM, Edson Lidorio wrote: On 21-04-2017 17:27, Scott Mead wrote: chown *-R* postgres:postgres /var/lib/pgsql/9.6/data Chown -R postgres: postgres /var/lib/pgsql/9.6/data Sudo

Re: [GENERAL] Recover PostgreSQL database folder data

database server. Apr 21 07:50:11 localhost systemd: Unit postgresql-9.6.service entered failed state. Apr 21 07:50:11 localhost systemd: postgresql-9.6.service failed. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Recover PostgreSQL database folder data

On 04/21/2017 01:14 PM, Edson Lidorio wrote: On 21-04-2017 16:00, Adrian Klaver wrote: Is that really the case? Yes, I have already given permission on this folder and it does not initialize. You do not want to initialize the directory that was taken care of when you did: 3- I renamed

Re: [GENERAL] Recover PostgreSQL database folder data

On 04/21/2017 10:09 AM, Edson Lidorio wrote: On 21-04-2017 13:48, Adrian Klaver wrote: On 04/21/2017 09:40 AM, Edson Lidorio wrote: Hi, There was a disaster in my development note. I was able to recover the data folder. PostgreSQL 9.6.2, was installed in Centos 7. Here are the procedures

Re: [GENERAL] pg_basebackup ----xlog-method=stream

s are available, but I wanted them included in the backup. Thanks! - Ian -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Recover PostgreSQL database folder data

to show in full. What do you see if you do the above, add -l to the systemctl command? What does the system log show? -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Unable to upload backups

"alter table x add column" you know that the new column is added last (if you refresh the table you will see it last). But if you add another GRANT statment to user it won't be in the last.. you have no way of knowing the correct order of GRANTS. ב אפר׳ 19, 2017 17:26, Adrian Klaver כ

Re: [GENERAL] referential integrity between elements of an array and another table?

? All I could find was a proposed change for 9.2 or 9.3 that got shot down... Please help. I don't want to do a join table. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Unable to upload backups

rather than by date so in case of overlaping instructions its impossible to know which one was first. ב אפר׳ 19, 2017 17:01, Adrian Klaver כתב: On 04/19/2017 06:49 AM, Ron Ben wrote: Is it possible to get your email program to left justify text on sending? I can figur

Re: [GENERAL] Unable to upload backups

habeticly rather than by date so in case of overlaping instructions its impossible to know which one was first. ב אפר׳ 19, 2017 16:40, Adrian Klaver כתב: On 04/19/2017 03:56 AM, Ron Ben wrote: > Hi, > I'm using PostgreSQL 9.3.2 > I'm running the command:

Re: [GENERAL] tuple statistics update

On 04/19/2017 12:28 AM, Tom DalPozzo wrote: 2017-04-18 21:42 GMT+02:00 Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>: On 04/17/2017 09:18 AM, Tom DalPozzo wrote: Hi, I'm using libpq to insert tuples in my table and keep looking at

Re: [GENERAL] Unable to upload backups

user "guest", database "production", SSL on FATAL: no pg_hba.conf entry for host "::1", user "guest", database "production", SSL off To get an overview of what users there are in your database cluster in psql do \du What can be the prob

Re: [GENERAL] tuple statistics update

nvoke pg_stat_clear_snapshot(), which will discard the current transaction's statistics snapshot (if any). The next use of statistical information will cause a new snapshot to be fetched." Regards Pupillo -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general ma

Re: [GENERAL] QGIS Loads Black Screen For PostGIS Out-Db Raster Data

On 04/18/2017 07:37 AM, Osahon Oduware wrote: I forgot to mention that I have put the question on the qgis-user mailing list. Thanks for your help. Great, because I don't have a clue where to go from here. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list

Re: [GENERAL] QGIS Loads Black Screen For PostGIS Out-Db Raster Data

to canvas. If the above does not answer the question I would say you will have a better chance of getting an answer here: http://lists.osgeo.org/mailman/listinfo/qgis-user I would be glad if someone could help me to resolve this. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgs

Re: [GENERAL] Nice to have features: Percentage function

Nolan -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Nice to have features: Percentage function

On 04/16/2017 09:37 AM, Melvin Davidson wrote: On Sun, Apr 16, 2017 at 12:23 PM, Adrian Klaver *Or, you could just as easily compute inline in SQL: SELECT datname, pg_size_pretty(pg_database_size(datname))as size_pretty, pg_database_size(datname) as size, (SELECT

Re: [GENERAL] Nice to have features: Percentage function

ect * from round(what_percent(10, 109), 2) ; round --- 9.17 If you think it's a good idea it would be nice if someone can implement this. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

Re: [GENERAL] Nice to have features: Percentage function

the 3 ooptions here: https://percentagecalculator.net/ It may help to keep code simple and clean and it seem like something simple to implement. If you think it's a good idea it would be nice if someone can implement this. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general

Re: [GENERAL] Error During PostGIS Build From Source on Linux

On 04/15/2017 11:25 AM, John R Pierce wrote: On 4/15/2017 10:49 AM, Adrian Klaver wrote: Probably going to involve dealing with ldconfig. Look in /etc/ld.so.conf and see if the directory that contains libproj.so.12 is in there? the catch-22 is, /etc/ld.so.conf is a global thing

Re: [GENERAL] Error During PostGIS Build From Source on Linux

.conf and see if the directory that contains libproj.so.12 is in there? I will be glad if anyone could help with this. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] financial formulae

at you are looking for is present. I believe the OP is referring to these: https://support.office.com/en-us/article/Financial-functions-reference-5658D81E-6035-4F24-89C1-FBF124C2B1D8 -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgres

Re: [GENERAL] Error During PostGIS Build From Source on Linux

00) liblzma.so.5 => /usr/lib64/liblzma.so.5 (0x7f9759eed000) /lib64/ld-linux-x86-64.so.2 (0x55ebafa02000) That will verify if postgis-2.3.so is linked to libproj. I would be glad if someone could point me to what I am doing wrong and possible solution. -- Adrian Klaver adrian.

Re: [GENERAL] Error During PostGIS Build From Source on Linux

roc xsl style sheets: dblatex: convert: /usr/bin/convert mathml2.dtd: http://www.w3.org/Math/DTD/mathml2/mathml2.dtd -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: htt

Re: [GENERAL] Error During PostGIS Build From Source on Linux

not compile with GEOS support. I would really suggest just installing the CentOS packages. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Error During PostGIS Build From Source on Linux

. Then Postgis built. On Apr 12, 2017 19:24, "Adrian Klaver" <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote: On 04/12/2017 11:11 AM, Rob Sargent wrote: On 04/12/2017 12:01 PM, Adrian Klaver wrote: On 04/12/2017 10:14 AM

Re: [GENERAL] Error During PostGIS Build From Source on Linux

on my part. That is why I initially suggested just using the Postgres Yum repos to install Postgres and Postgis. Then the build process is taken care of for you. On Apr 12, 2017 19:24, "Adrian Klaver" <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote:

Re: [GENERAL] Error During PostGIS Build From Source on Linux

On 04/12/2017 11:11 AM, Rob Sargent wrote: On 04/12/2017 12:01 PM, Adrian Klaver wrote: On 04/12/2017 10:14 AM, Osahon Oduware wrote: Hi All, I am working on a Linux OS (Centos 6.5). I built GDAL successfully from source as below: ./configure --prefix=/path/to/gdal make make install Next I

Re: [GENERAL] Error During PostGIS Build From Source on Linux

://www.postgresql.org/download/linux/redhat/ -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] postgresql-plperl-9.4 : Depends: libperl5.18 (>= 5.18.2) but it is not installable

by MIMOS Berhad and/or its subsidiaries and neither MIMOS Berhad nor its subsidiaries accepts responsibility for the same. All liability arising from or in connection with computer viruses and/or corrupted e-mails is excluded to the fullest extent permitted by law. -- Adrian Klaver adrian.kla

Re: [GENERAL] Unable to connect to Postgresql

to be updated. Seems I missed a message: " I just installed everything (APache, Postgresql, PHP, OpenSSL from source as I always have over a period of more than 15 years." Best regards, -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing l

Re: [GENERAL] Unable to connect to Postgresql

a source install or did you copy a postgresql.conf from somewhere else? Best regards, -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Unable to connect to Postgresql

to be updated. Seems to me that it would be easier to try: PrivateTmp=false in the httpd systemd file. Best regards, -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Unable to connect to Postgresql

On 04/09/2017 05:30 PM, John Iliffe wrote: On Sunday 09 April 2017 20:01:32 Adrian Klaver wrote: So the issue is in PHP via Apache using the socket, because if I remember right you used localhost in the Apache/PHP combination and it worked, correct? Yes. I think there is some confusion

Re: [GENERAL] Unable to connect to Postgresql

ned. Alter pg_hba.conf so that localhost is declared and let's see what happens. It will be the same effect, the commented line is just showing that the default is 'localhost'. Though, John if you do decide to do this remember to restart the server to have the change take effect. Cheers, Rob

Re: [GENERAL] Unable to connect to Postgresql

On 04/09/2017 02:35 PM, John Iliffe wrote: On Sunday 09 April 2017 17:02:47 Adrian Klaver wrote: On 04/09/2017 02:00 PM, John Iliffe wrote: On Sunday 09 April 2017 15:38:10 Adrian Klaver wrote: Remember host != local host is for IP connections local is for socket connections Yes, I had

Re: [GENERAL] Unable to connect to Postgresql

On 04/09/2017 02:00 PM, John Iliffe wrote: On Sunday 09 April 2017 15:38:10 Adrian Klaver wrote: Remember host != local host is for IP connections local is for socket connections Yes, I had forgotten that for the moment. I have the following line in the 'local' section of the pg_hba.conf

Re: [GENERAL] Unable to connect to Postgresql

On 04/09/2017 12:37 PM, John Iliffe wrote: On Sunday 09 April 2017 14:34:01 Joe Conway wrote: On 04/09/2017 11:33 AM, John Iliffe wrote: On Saturday 08 April 2017 18:10:35 Joe Conway wrote: On 04/08/2017 01:23 PM, John Iliffe wrote: On Saturday 08 April 2017 09:38:07 Adrian Klaver wrote: So

Re: [GENERAL] Unable to connect to Postgresql

On 04/09/2017 11:33 AM, John Iliffe wrote: On Saturday 08 April 2017 18:10:35 Joe Conway wrote: On 04/08/2017 01:23 PM, John Iliffe wrote: On Saturday 08 April 2017 09:38:07 Adrian Klaver wrote: So what if you change the connection to use -h localhost? Can you please expand on that request

Re: [GENERAL] Aggregate query on large tables

view. Than you! /F -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Unable to connect to Postgresql

On 04/08/2017 06:26 AM, John Iliffe wrote: On Saturday 08 April 2017 00:10:14 Adrian Klaver wrote: On 04/07/2017 07:45 PM, Joe Conway wrote: On 04/07/2017 05:35 PM, Adrian Klaver wrote: On 04/07/2017 05:03 PM, John Iliffe wrote: Running on Fedora 25 with SELinux in PERMISSIVE mode

Re: [GENERAL] A change in the Debian install

On 04/07/2017 08:56 PM, rob stone wrote: Hello Adrian, On Thu, 2017-04-06 at 21:24 -0700, Adrian Klaver wrote: On 04/06/2017 08:01 PM, rob stone wrote: That is the default location and is generally the case in a source install. Package maintainers can and do often put them elsewhere

Re: [GENERAL] Unable to connect to Postgresql

On 04/07/2017 07:45 PM, Joe Conway wrote: On 04/07/2017 05:35 PM, Adrian Klaver wrote: On 04/07/2017 05:03 PM, John Iliffe wrote: Running on Fedora 25 with SELinux in PERMISSIVE mode. The audit log shows no hits on Postgresql. My going in position was/still is, that this is a SELinux

Re: [GENERAL] Unable to connect to Postgresql

) to provide a secondary domain where the actual business processes run. So, I guess the answer is that the current arrangement has never run correctly. Regards, John -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Unable to connect to Postgresql

= -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Unable to connect to Postgresql

was the last time you could connect and has anything of note happened since then? Regards, John === On Friday 07 April 2017 18:51:33 Adrian Klaver wrote: On 04/07/2017 02:38 PM, John Iliffe wrote: When I attempt to run any web application php cannot open a database

Re: [GENERAL] Unable to connect to Postgresql

, the postgresql log shows nothing since the last start up. Meant to add to previous post: What happens if you try to connect to the database using psql? Thanks in advance. John = -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general

Re: [GENERAL] Unable to connect to Postgresql

, the postgresql log shows nothing since the last start up. Well the last time this happened the answer was this: https://www.postgresql.org/message-id/25543.1489081789%40sss.pgh.pa.us Thanks in advance. John = -- Adrian Klaver adrian.kla

Re: [GENERAL] SELECT and RowExclusiveLock

;, "price_benefit"."create_datetime", "price_benefit". It would help to have: 1) Schema definitions for sales_transaction_detail and sales_transaction_header 2) The complete queries. 3) And just for grins the Postgres version. -- Adrian Klaver adrian.kla...@

Re: [GENERAL] keeping WAL after dropping replication slots

On 04/06/2017 11:18 PM, Tom DalPozzo wrote: Hi, 2017-04-06 21:51 GMT+02:00 Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>: On 04/04/2017 11:52 PM, Tom DalPozzo wrote: Hi, 2017-04-05 1:55 GMT+02:00 Adrian Klaver

Re: [GENERAL] A change in the Debian install

On 04/06/2017 08:01 PM, rob stone wrote: On Thu, 2017-04-06 at 15:58 -0700, Adrian Klaver wrote: On 04/06/2017 03:16 PM, rob stone wrote: Which is what has me confused. If you are using the postgresql- common system then the *.conf files should be in /etc/postgresql/version/cluster_name

Re: [GENERAL] A change in the Debian install

On 04/06/2017 03:16 PM, rob stone wrote: On Wed, 2017-04-05 at 21:14 -0700, Adrian Klaver wrote: What repos are you using, the Debian or the PGDG one? I guess the question I should really ask is, are you using a repo or some other method to upgrade? Upgraded from standard Debian repos

Re: [GENERAL] keeping WAL after dropping replication slots

On 04/04/2017 11:52 PM, Tom DalPozzo wrote: Hi, 2017-04-05 1:55 GMT+02:00 Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>: On 04/04/2017 07:45 AM, Tom DalPozzo wrote: Postgres version? 9.6.1 Hi, I had two replication slots o

Re: [GENERAL] Advise on primary key for detail tables (OS: Raspberry Pi)

On 04/06/2017 06:40 AM, Ertan Küçükoğlu wrote: -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Thursday, April 6, 2017 4:18 PM To: Ertan Küçükoğlu <ertan.kucuko...@1nar.com.tr>; pgsql-general@postgresql.org Subject: Re: [GENERAL] Advise on prima

Re: [GENERAL] Advise on primary key for detail tables (OS: Raspberry Pi)

the question, why have the uuid column? -Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Wednesday, April 5, 2017 7:17 PM To: Ertan Küçükoğlu <ertan.kucuko...@1nar.com.tr>; pgsql-general@postgresql.org Subject: Re: [GENERAL] Advise on primary key for

Re: [GENERAL] A change in the Debian install

e PGDATA is pointing. That is packaging dependent. When using the Debian/Ubuntu postgresql-common system the postgresql.conf will be in /etc/postgresql/version/cluster_name/ Has anybody else struck this issue? Cheers, Rob -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing

Re: [GENERAL] browser interface to forums please?

On 04/05/2017 10:57 AM, Joshua D. Drake wrote: On 04/05/2017 10:45 AM, Adrian Klaver wrote: On 04/05/2017 10:26 AM, Tim Clarke wrote: +1 Joshua, that's the best reason I've heard so far and it seems very powerful to me. The more readers we have and the easier they can communicate with us

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