neeraj kumar writes:
> Tom, may be I didn't make my point clear.
> There are two issues :
> 1) Why this value was left as odd
Because a function called by pgstat_bestart threw an error, is what
I'm guessing.
> 2) Why backend entry is still pending in beentry for backend process even
> after it w
neeraj kumar writes:
> We got more information about this issue. There is one backend process
> still present into beentry which has changecount as odd value. However this
> process is long gone/terminated. It means when this process was
> killed/terminated its entry was not cleaned from beentry l
On Wed, May 8, 2019 at 04:23:06PM -0500, Ron wrote:
> On 5/8/19 3:30 PM, Sandeep Saxena wrote:
> [snip]
> > @Ravi
> > My company is trying to avoid another vendor lockin too , thats why we
> > are bit skeptical on going to EDB as once we start using their Oracle
> > compatability
> > feature then
Hello,
I want to build a custom postgresql-server from source packages to
change and test some compile time parameters.
I didn't find any guide on how to do this.
Any advice of guide?
Thanks
https://github.com/pgaudit/pgaudit might help. It's packed for install by
the Postgres team, (Of course, it's too late for existing accounts.)
On 5/9/19 4:11 PM, Kumar, Virendra wrote:
Thanks Chris!
Since PostgreSQL still have to have those accounts even if we authenticate
it externally we
Thanks Chris!
Since PostgreSQL still have to have those accounts even if we authenticate it
externally we have to get at least the user creation date from the instance as
that information might be different in instance vs external utility. Is there a
possibility we can get it.
Most of our accou
On Thu, 9 May 2019 at 16:43, Kumar, Virendra
wrote:
> Hello Team,
>
>
>
> We are looking for some audit information about user creation. We need a
> few audit fields which we did not find in PostgreSQL. I would be happy if
> someone help us in finding these details. Besically we need information
Hello Team,
We are looking for some audit information about user creation. We need a few
audit fields which we did not find in PostgreSQL. I would be happy if someone
help us in finding these details. Besically we need information about:
1. User creation date
2. Last Password chang
Hello,
A client has recently had a couple of hot standby query conflict pile-ups
around AccessShare lock waits on pg_attribute. Here is an example from the
log:
Mar 27 12:06:37 ip-10-0-125-5 7dc68e48_fbd9_41d7_9ab1_65599036dd75[118946]:
[9-1] sql_error_code = 0 LOG: process 118946 still wa
Jeremy Schneider writes:
> Seems to me that at a minimum, this loop shouldn't go on forever. Even
> having an arbitrary, crazy high, hard-coded number of attempts before
> failure (like a million) would be better than spinning on the CPU
> forever - which is what we are seeing.
I don't think it's
Greetings,
(Dropping all the extra mailing lists and such, please do *not*
cross-post like that)
* M Tarkeshwar Rao (m.tarkeshwar@ericsson.com) wrote:
> We want to setup ldap authentication in pg_hba.conf, for Postgresql
> users(other than postgres super user).
>
> We are getting issue wi
On 5/9/19 9:58 AM, Prakash Ramakrishnan wrote:
Hi David,
I did the installation for using postgresql 10.4 version edb standard
edition.so again need to run the yum command or please advise me .
I don't have time to go through the below, but some issues filed at
pgbackrest about using EDB ins
On 5/9/19 9:58 AM, Prakash Ramakrishnan wrote:
Hi David,
I did the installation for using postgresql 10.4 version edb standard
edition.so again need to run the yum command or please advise me .
Should have added to previous post. A heads up:
Postgres 10.x is the last Linux version you can us
On Thu, 2019-05-09 at 16:49 +, Julie Nishimura wrote:
> Alan, thanks for your reply.
>
>
>
>
>
>
>
> So, we currently have this situation:
>
>
>
>
>
>
>
> /dev/sda1 2.7T 2.4T 298G 90% /data/vol1
>
>
> /dev/sdb2 2.7T 2.4T 296G 89% /data/vol2
>
>
>
On 5/9/19 9:54 AM, David Steele wrote:
On 5/9/19 12:51 PM, Prakash Ramakrishnan wrote:
Hi Adrian,
I don't know about that client libraries can you please explain or share
me the command I will show you the output and we need the solution for
this pgbackrest issue .
yum install postgresql10
On 5/9/19 12:58 PM, Prakash Ramakrishnan wrote:
>
> I did the installation for using postgresql 10.4 version edb standard
> edition.so again need to run the yum command or please advise me .
It really depends on how you've installed EDB, packages or their
customer installer.
The custom installer
On 5/9/19 12:58 PM, Adrian Klaver wrote:
> On 5/9/19 9:54 AM, David Steele wrote:
>> On 5/9/19 12:51 PM, Prakash Ramakrishnan wrote:
>>> Hi Adrian,
>>>
>>> I don't know about that client libraries can you please explain or share
>>> me the command I will show you the output and we need the solution
On 5/9/19 9:58 AM, Prakash Ramakrishnan wrote:
Hi David,
I did the installation for using postgresql 10.4 version edb standard
edition.so again need to run the yum command or please advise me .
So you are using the EDB installer correct?
If so YUM is not going to help you.
Regards,
Prakas
Hi David,
I did the installation for using postgresql 10.4 version edb standard
edition.so again need to run the yum command or please advise me .
Regards,
Prakash.R
On Thu, May 9, 2019, 22:24 David Steele wrote:
> On 5/9/19 12:51 PM, Prakash Ramakrishnan wrote:
> > Hi Adrian,
> >
> > I don't
On 5/9/19 12:51 PM, Prakash Ramakrishnan wrote:
> Hi Adrian,
>
> I don't know about that client libraries can you please explain or share
> me the command I will show you the output and we need the solution for
> this pgbackrest issue .
yum install postgresql10
should do it, but I thought pqlib
Alan, thanks for your reply.
So, we currently have this situation:
/dev/sda1 2.7T 2.4T 298G 90% /data/vol1
/dev/sdb2 2.7T 2.4T 296G 89% /data/vol2
/dev/mapper/vg00-data
16T 16T 373G 98% /data/vol3
postgres=# SELECT * FROM pg_tablespace;
Thanks for your help, Adrian!
From: Adrian Klaver
Sent: Thursday, May 9, 2019 9:41 AM
To: Julie Nishimura
Cc: pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: postgresql 9.4 restart
On 5/9/19 8:10 AM, Julie Nishimura wrote:
> Etc/UTC
Well there goe
Hi Adrian,
I don't know about that client libraries can you please explain or share me
the command I will show you the output and we need the solution for this
pgbackrest issue .
Regards,
Prakash.R
On Thu, May 9, 2019, 22:07 Adrian Klaver wrote:
> On 5/9/19 8:12 AM, Prakash Ramakrishnan wrot
On 5/9/19 8:10 AM, Julie Nishimura wrote:
Etc/UTC
Well there goes that theory:(
Not sure where to go from here, other then monitor the logs and
connections more aggressively.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 5/9/19 8:12 AM, Prakash Ramakrishnan wrote:
Yes, I did.
The server is there, but where the client libraries installed?
What does your package manager show for installed Postgres packages?
postgres 12546 1 0 Apr28 ? 00:03:07
/opt/app/PostgreSQL/10/bin/postgres
postgres 12554
On 5/9/19 11:12 AM, Prakash Ramakrishnan wrote:
> Yes, I did.
OK, then I would say something is wrong with your package configuration,
but I don't know what it might be.
Regards,
--
-David
da...@pgmasters.net
On Thu, 2019-05-09 at 15:46 +, Julie Nishimura wrote:
> hello,
>
> We are running out of disk space, and we introduced new volume to it.
> I am about to create new tablespace X and alter user databases to set
> to this new tablespace X. So, all new tables will be created in X,
> but what about
hello,
We are running out of disk space, and we introduced new volume to it. I am
about to create new tablespace X and alter user databases to set to this new
tablespace X. So, all new tables will be created in X, but what about existing
tables on previous volume? Its data will be split between
Yes, I did.
postgres 12546 1 0 Apr28 ?00:03:07
/opt/app/PostgreSQL/10/bin/postgres
postgres 12554 12546 0 Apr28 ?00:04:12 postgres: logger process
postgres 12557 12546 0 Apr28 ?01:06:28 postgres: checkpointer
process
postgres 12558 12546 0 Apr28 ?00:01:57 po
Etc/UTC
From: Adrian Klaver
Sent: Thursday, May 9, 2019 7:51 AM
To: Julie Nishimura
Cc: pgsql-general@lists.postgresql.org; pgsql-general
Subject: Re: postgresql 9.4 restart
On 5/8/19 4:35 PM, Julie Nishimura wrote:
> Thanks again for your help.
>
> 1) max_connec
On 5/9/19 10:57 AM, Prakash Ramakrishnan wrote:
>
> David am trying to restore the backup in dev server please find the
> below details ,
libpq should be installed with Postgres. Have you installed Postgres yet?
--
-David
da...@pgmasters.net
Thanks, I'll check it out.
David am trying to restore the backup in dev server please find the below
details ,
[root@sydcosausd001 ~]# yum install perl perl-Time-HiRes perl-Digest-SHA
perl-DBD-Pg perl-JSON-PP
Loaded plugins: fastestmirror, product-id, search-disabled-repos,
subscription-manager
D
On 5/8/19 4:35 PM, Julie Nishimura wrote:
Thanks again for your help.
1) max_connections is set to 500 in our config file
2) our average conn load is 300-400, however, I am not sure if it was
close to max_conn at the moment of restart
3) we do not have replication on this staging server
4) The
On 5/9/19 9:39 AM, Adrian Klaver wrote:
> On 5/9/19 4:53 AM, Prakash Ramakrishnan wrote:
>>
>> We having perl issue for while during restore operation for using
>> pgbackrest backup tool can you please do the needful.
>
> Looks to me like the Postgres client library libpq is not installed or
> can
On 5/9/19 6:14 AM, Chuck Martin wrote:
I have several columns that were created as "timestamp without time
zone", but I changed them in 2014 to "timestamp with time zone".
Recently, when I got notified that times had suddenly changed, I checked
and found the columns had reverted to "timestamp w
Yes we use SSL to connect to DB.
Looked into code related to st_changecount :
https://github.com/postgres/postgres/blob/659e53498c3c04e4f400323c02bef98fe8d13ec8/src/include/pgstat.h#L1015-L1044
>From comment seems like each backend should have its own copy
of PgBackendStatus, it means st_changeco
On 5/9/19 6:14 AM, Chuck Martin wrote:
I have several columns that were created as "timestamp without time
zone", but I changed them in 2014 to "timestamp with time zone".
Recently, when I got notified that times had suddenly changed, I checked
and found the columns had reverted to "timestamp w
On Thursday, May 9, 2019, Chuck Martin wrote:
> I have several columns that were created as "timestamp without time zone",
> but I changed them in 2014 to "timestamp with time zone". Recently, when I
> got notified that times had suddenly changed, I checked and found the
> columns had reverted to
On 5/9/19 4:53 AM, Prakash Ramakrishnan wrote:
Hi Team,
We having perl issue for while during restore operation for using
pgbackrest backup tool can you please do the needful.
Looks to me like the Postgres client library libpq is not installed or
cannot be found on this machine.
You will
I have several columns that were created as "timestamp without time zone",
but I changed them in 2014 to "timestamp with time zone". Recently, when I
got notified that times had suddenly changed, I checked and found the
columns had reverted to "timestamp without time zone." This seems
impossible, y
On Thu, May 09, 2019 at 07:11:24AM +, M Tarkeshwar Rao wrote:
We want to setup ldap authentication in pg_hba.conf, for Postgresql
users(other than postgres super user).
We are getting issue with special characters by following steps given in
postgres documentation. It is not accepting any
Hi Team,
We having perl issue for while during restore operation for using
pgbackrest backup tool can you please do the needful.
2019-05-08 18:42:09.415 P00 INFO: restore command begin 2.13:
--db-include=A4_Copy --log-level-console=info
--pg1-path=/Postgres/prakash_pgbackrest --process-max=2 --
On Thu, 2019-05-09 at 07:11 +, M Tarkeshwar Rao wrote:
> We want to setup ldap authentication in pg_hba.conf, for Postgresql
> users(other than postgres super user).
>
> We are getting issue with special characters by following steps given in
> postgres documentation.
> It is not acceptin
We want to setup ldap authentication in pg_hba.conf, for Postgresql
users(other than postgres super user).
We are getting issue with special characters by following steps given in
postgres documentation.
It is not accepting any special characters as special characters are mandatory
in our us
44 matches
Mail list logo