Re: [GENERAL] PostgrSQL server : CPU and Memory

On 5/17/2017 8:50 PM, kaustubh kelkar wrote: I am a developer and I want to monitor metrics related to CPU and Memory of PostgreSQL server only using SQL queries. postgres itself doesn't track that level of OS specific stuff. Do we have any system tables which can give us the data? I have

[GENERAL] PostgrSQL server : CPU and Memory

Hi , I am a developer and I want to monitor metrics related to CPU and Memory of PostgreSQL server only using SQL queries. Do we have any system tables which can give us the data? I have found this one https://aaronparecki.com/2015/02/19/8/monitoring-cpu-memory-usage-from-postgres but dont know

Re: [GENERAL] column names and dollar sign

On 18/05/17 11:59, John R Pierce wrote: On 5/17/2017 4:51 PM, Gavin Flower wrote: Variables ending in '$' date back to at least the early days of BASIC - long before the spectre of Microsoft loomed large, let alone 'Visual Basic'! I note even INT fields have $ names there... IBM used to

Re: [GENERAL] column names and dollar sign

On 5/17/2017 4:51 PM, Gavin Flower wrote: Variables ending in '$' date back to at least the early days of BASIC - long before the spectre of Microsoft loomed large, let alone 'Visual Basic'! I note even INT fields have $ names there... IBM used to like to use $ in names for system stuff,

Re: [GENERAL] column names and dollar sign

On 18/05/17 11:32, Neil Anderson wrote: "Armand Pirvu (home)" writes: Ran into the following statement CREATE TABLE test( Date$ date, Month_Number$ int, Month$ varchar(10), Year$ int ); A strange naming convention. It has a whiff of Visual Basic

Re: [GENERAL] column names and dollar sign

>> "Armand Pirvu (home)" writes: >>> Ran into the following statement >> >>> CREATE TABLE test( >>> Date$ date, >>> Month_Number$ int, >>> Month$ varchar(10), >>> Year$ int >>> ); A strange naming convention. It has a whiff of Visual Basic Type

Re: [GENERAL] column names and dollar sign

Thanks Tom Armand On May 17, 2017, at 4:14 PM, Tom Lane wrote: > "Armand Pirvu (home)" writes: >> Ran into the following statement > >> CREATE TABLE test( >> Date$ date, >> Month_Number$ int, >> Month$ varchar(10), >> Year$

Re: [GENERAL] column names and dollar sign

"Armand Pirvu (home)" writes: > Ran into the following statement > CREATE TABLE test( > Date$ date, > Month_Number$ int, > Month$ varchar(10), > Year$ int > ); > While it does execute, I wonder if the $ has any special meaning ? Postgres thinks

Re: [GENERAL] column names and dollar sign

Thank you Steve — Armand On May 17, 2017, at 4:10 PM, Steve Atkins wrote: > >> On May 17, 2017, at 2:02 PM, Armand Pirvu (home) >> wrote: >> >> Hi >> >> Ran into the following statement >> >> CREATE TABLE test( >> Date$ date, >>

Re: [GENERAL] column names and dollar sign

> On May 17, 2017, at 2:02 PM, Armand Pirvu (home) > wrote: > > Hi > > Ran into the following statement > > CREATE TABLE test( > Date$ date, > Month_Number$ int, > Month$ varchar(10), > Year$ int > ); > > > While it does execute, I wonder if

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

Adrian Klaver writes: > I could build repmgr against Postgres source and on Ubuntu install of > EDB Postgres. The issue seems to be a combination of RH and EDB Postgres > installation. To me it looks like ld is finding > /lib64/libldap_r-2.4.so.2 library before the

[GENERAL] column names and dollar sign

Hi Ran into the following statement CREATE TABLE test( Date$ date, Month_Number$ int, Month$ varchar(10), Year$ int ); While it does execute, I wonder if the $ has any special meaning ? Can anyone shed some light please ? Thanks Armand -- Sent via

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

On 05/17/2017 01:28 PM, Martin Goodson wrote: On 17/05/2017 20:11, Adrian Klaver wrote: I thought you where working on VM you had access/rights to. That is not the case? I have sudo access on the redhat box we're working on so technically I could do this, yup. But whilst our Unix team

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

On 17/05/2017 20:11, Adrian Klaver wrote: I thought you where working on VM you had access/rights to. That is not the case? I have sudo access on the redhat box we're working on so technically I could do this, yup. But whilst our Unix team are happy for us to do whatever the heck we like

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

On 05/17/2017 12:01 PM, Martin Goodson wrote: On 17/05/2017 17:19, Adrian Klaver wrote: Spun up a RH 7.3 instance and tried the compile and got the same error. Good to know it's reproducible, and not just me :) I'll have a word with our UNIX team about unlinking this (and relinking

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

On 17/05/2017 17:19, Adrian Klaver wrote: Spun up a RH 7.3 instance and tried the compile and got the same error. Good to know it's reproducible, and not just me :) To fix, find the checking library in /lib64/libldap_r-2.4.so.2. [root@localhost repmgr-2.0]# cd /lib64/ [root@localhost

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

On 17/05/2017 16:15, Adrian Klaver wrote: On 05/17/2017 07:26 AM, Martin Goodson wrote: On 16/05/2017 18:46, Adrian Klaver wrote: Per Tom's suggestion try ldd /db_demo/app/postgres/9.6.2-3/lib/libldap_r-2.4.so.2 Hello. Apologies for the delay in replying - medical appointment this morning

Re: [GENERAL] PSQL command line print speed

On 05/17/2017 09:46 AM, Adrian Myers wrote: Ah I should have mentioned, the pager is off. Is that by choice and if so why? With the pager off you have to wait for the entire output to write to the screen. For anything but a small dataset that is going to take time. -- Adrian Klaver

Re: [GENERAL] database is not accepting commands

On Tue, May 16, 2017 at 1:28 AM, reem wrote: > We have 1.5 TB database that's shown an error and block all commands. > The error is : > "ERROR: database is not accepting commands to avoid wraparound data loss > in > database "dbname" > HINT: Stop the postmaster and use a

Re: [GENERAL] PSQL command line print speed

Adrian: On Wed, May 17, 2017 at 6:03 PM, Adrian Myers wrote: > Queries which perform in a few milliseconds through a driver (psycopg2 in > this case) can take several seconds or minutes to complete in the console, > seemingly just due to it printing lines at a very

Re: [GENERAL] PSQL command line print speed

Ah I should have mentioned, the pager is off. On Wed, May 17, 2017 at 12:34 PM, Adrian Klaver wrote: > On 05/17/2017 09:22 AM, Adrian Myers wrote: > > Please reply to list also > Ccing list > > Hi Adrian, it is running locally. >> > > In addition to Pavel's

Re: [GENERAL] PSQL command line print speed

On 05/17/2017 09:22 AM, Adrian Myers wrote: Please reply to list also Ccing list Hi Adrian, it is running locally. In addition to Pavel's suggestions: In psql what does \pset show for the pager setting? On Wed, May 17, 2017 at 12:21 PM, Adrian Klaver

Re: [GENERAL] PSQL command line print speed

On 05/17/2017 09:03 AM, Adrian Myers wrote: Is there a way to speed up the actual line-by-line display of the psql console in version 8.4? Queries which perform in a few milliseconds through a driver (psycopg2 in this case) can take several seconds or minutes to complete in the console,

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

On 05/17/2017 07:26 AM, Martin Goodson wrote: On 16/05/2017 18:46, Adrian Klaver wrote: Per Tom's suggestion try ldd /db_demo/app/postgres/9.6.2-3/lib/libldap_r-2.4.so.2 Hello. Apologies for the delay in replying - medical appointment this morning :) Anyway, executed that command as

Re: [GENERAL] PSQL command line print speed

Hi 2017-05-17 18:03 GMT+02:00 Adrian Myers : > Is there a way to speed up the actual line-by-line display of the psql > console in version 8.4? > > Queries which perform in a few milliseconds through a driver (psycopg2 in > this case) can take several seconds or minutes

[GENERAL] PSQL command line print speed

Is there a way to speed up the actual line-by-line display of the psql console in version 8.4? Queries which perform in a few milliseconds through a driver (psycopg2 in this case) can take several seconds or minutes to complete in the console, seemingly just due to it printing lines at a very

Re: [GENERAL] sorry, too many clients already error

The log_connections helped. I was able to diagnose the problem. The connections are getting closed but my setup is actually generating too many connections. Thanks for helping with this. -sandeep On Tue, May 16, 2017 at 6:53 PM, Tom Lane wrote: > Sandeep Gupta

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

On 05/17/2017 07:26 AM, Martin Goodson wrote: On 16/05/2017 18:46, Adrian Klaver wrote: Per Tom's suggestion try ldd /db_demo/app/postgres/9.6.2-3/lib/libldap_r-2.4.so.2 Hello. Apologies for the delay in replying - medical appointment this morning :) Anyway, executed that command as

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

On 16/05/2017 18:46, Adrian Klaver wrote: Per Tom's suggestion try ldd /db_demo/app/postgres/9.6.2-3/lib/libldap_r-2.4.so.2 Hello. Apologies for the delay in replying - medical appointment this morning :) Anyway, executed that command as suggested and this is the output I got.

Re: [GENERAL] storing large files in database - performance

On Tue, May 16, 2017 at 9:51 AM, Thomas Kellerer wrote: > John R Pierce schrieb am 16.05.2017 um 16:44: >> On 5/16/2017 7:35 AM, Thomas Kellerer wrote: >>> When my (JDBC based) SQL client and the database server are on the same >>> computer... >> >> node.js is Javascript, not

Re: [GENERAL] database is not accepting commands

On 05/16/2017 10:44 PM, reem wrote: postgres 9.3 in ubuntu OS. Meant to add to previous post. What is the full version number of Postgres e.g. 9.3.x? -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] database is not accepting commands

On 05/16/2017 10:44 PM, reem wrote: postgres 9.3 in ubuntu OS. Yes I did this : 1- service postgresql stop 2- /usr/lib/postgresql/9.3/bin/postgres --single -D /var/lib/postgresql/9.3/main -c config_file=/etc/postgresql/9.3/main/postgresql.conf dbname 3-vacuum verbose 4- vacumming processed and