Adrian:
On Wed, May 17, 2017 at 8:40 PM, Adrian Klaver
wrote:
> 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
CCing the list.
Adrian:
On Wed, May 17, 2017 at 6:58 PM, Adrian Myers wrote:
> That is a great question, and no, I'm not. This is on Windows and I see this
> with normal cmd.exe and ConEmu but I have been using ConEmu for some time
> and have not looked into settings there. Thanks for that sugge
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 fo
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
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 l
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,
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 Type
Characters about it
>> "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
Characters about it,
https://doc
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$ int
>> );
>
>> While it does execute, I wonder
"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 it's a valid identifier ch
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,
>> Month_Number$ int,
>> Month$ varchar(10),
>>
> 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 the $ has any special me
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 /opt/PostgreSQL/9.6/lib/
> o
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 pgsql-
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 are
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
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
afterwa
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 lib64]#
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
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
adrian
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 standalone backend to v
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 leisurely pace (in other
> word
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 suggestions:
>
> In psql what does \ps
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
mailto:adrian.kla...@aklaver.com>>
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, seemi
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 suggeste
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 to complete in the console
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 leis
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 writes:
>> I have set max_connect
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 suggeste
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.
pginst@testd
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 java w/ jdbc
>
> I k
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 su
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 i
34 matches
Mail list logo
