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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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)
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
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)
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
>
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
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
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
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
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,
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
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
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
On Wed, 2019-05-08 at 12:42 -0700, Adrian Klaver wrote:
> At this point I would say your are going to need to go back to the last
> clean backup and restore from there into a clean instance of Postgres on
> a clean version of whatever OS you are running on.
... and of course, plug the hole
On Thu, 2019-05-09 at 04:51 +, M Tarkeshwar Rao wrote:
> We would need to integrate Postgres Users Authentication with our own LDAP
> Server.
>
> Basically as of now we are able to login to Postgress DB with a user/password
> credential.
>
> [roles "pg_signal_backend" and "postgres"]
>
On 9/5/19 7:51 π.μ., M Tarkeshwar Rao wrote:
Hi all,
We would need to integrate Postgres Users Authentication with our own LDAP
Server.
Basically as of now we are able to login to Postgress DB with a user/password
credential.
These user objects are the part of Postgres DB server. Now we
46 matches
Mail list logo
