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 throu
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 wan
Thanks Jeremy,
I tried using the --nodeps but hit problems when trying to use the
repo, such gpg signatures etc.
It's more the fact that you can't add repo's for packages that are
pretty well compatible, where I figured the effort would be reasonably
small.
Thanks for the sed tip, I'll see how I f
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.
[cid:image001.png@01D50650.D807AE30]
These user objects are the part of Postgres DB server. Now we want that thes
Brent,
On Tue, May 7, 2019 at 12:42 PM Brent Wood wrote:
> I have not used SS for spatial data, but I don't have a Postgres database
> without Postgis installed. The OSGEO ecosystem and synergies with other
> FOSS GIS tools is fantastic.
>
> And it does not stop with the Postgis extension. For t
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) These are the snippets from auth logs with the c
neeraj kumar writes:
> Yes we use SSL to connect to DB.
Hm. I'm suspicious that one of the functions that fetch data for
an SSL connection threw an error. In particular, it doesn't look
to be hard at all to make X509_NAME_to_cstring fall over --- an
encoding conversion failure would do it, even
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 it will be very difficult to move to community addition again.
What ab
On 5/8/19 2:01 PM, Julie Nishimura wrote:
Adrian, thanks for your reply!
PostgreSQL 9.4.21 on x86_64-pc-linux-gnu (Ubuntu 9.4.21-1.pgdg16.04+1),
compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.11) 5.4.0 20160609, 64-bit
This is what Ive found in logs prior to the restart:
UTC,"hitwise","hitw
Adrian, thanks for your reply!
PostgreSQL 9.4.21 on x86_64-pc-linux-gnu (Ubuntu 9.4.21-1.pgdg16.04+1),
compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.11) 5.4.0 20160609, 64-bit
This is what Ive found in logs prior to the restart:
2019-05-07 00:08:26.771
UTC,,,8677,"10.200.193.58:49428",5cd0cc7a
>@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 it will be very difficult to move to community addition again.
As far as I know, vendor lock in applies only if
Actually I ran our schema against AWS Schema conversion tool ,and when i
looked at converted code then i saw that for some stuff it was using other
services of AWS which is only in AWS ,
So thats what i meant by not using AWS services and just keeping usage of
Postgres and its extensions.
@Ravi
My
On 5/8/19 8:39 AM, Sandeep Saxena wrote:
Hi All,
In our company we are looking to migrate oracle db to postgres , now
since we dont have any expertise in Postgres in our organization so we
are planning to go
with AWS aurora or EDB postgres so that we have helping hand in
migration(in dev and
st 8. 5. 2019 v 17:40 odesílatel Sandeep Saxena
napsal:
> Hi All,
>
> In our company we are looking to migrate oracle db to postgres , now since
> we dont have any expertise in Postgres in our organization so we are
> planning to go
> with AWS aurora or EDB postgres so that we have helping hand i
On 5/8/19 9:04 AM, Prashant Hunnure wrote:
Please reply to list also.
Ccing list.
Hi Adrian,
Thanks for the reply.
As my public schema under the said database has been renamed by public
bla bla bla.and the .map file from the global folder is in encrypted
format.
At this point I would s
On 5/8/19 11:00 AM, Julie Nishimura wrote:
Hello,
Our staging 9.4 postgresql has been running couple of weeks with no
problem, but yesterday we saw this error from one of our services that
connects to the staging DBs:
FATAL: terminating connection due to
administrator command; nested exceptio
Took some time to get stack trace as we didn't had root permission.
Attaching stack trace of two process (out of many) stuck for same query
below[1][2]
Seems like call is unable to come out of this loop :
https://github.com/postgres/postgres/blob/master/src/backend/postmaster/pgstat.c#L3361-L3400
neeraj kumar writes:
> Took some time to get stack trace as we didn't had root permission.
> Attaching stack trace of two process (out of many) stuck for same query
> below[1][2]
Hmm, the line numbers in your stack traces don't agree with either v10
or HEAD branches for me. But assuming that you
Hello,
Our staging 9.4 postgresql has been running couple of weeks with no problem,
but yesterday we saw this error from one of our services that connects to the
staging DBs:
FATAL: terminating connection due to
administrator command; nested exception is
org.postgresql.util.PSQLException: FATAL:
Hi!
On Wed, May 8, 2019 at 6:09 AM Alvaro Herrera wrote:
> If you want to complain about JSON, it's IETF that you need to talk
> about, not us -- we're just implementing their spec. As for storing the
> numbers in a database, you can already do that, just not on the JSON
> datatype.
Yes, I see
On 5/6/19 23:27, Rashmi V Bharadwaj wrote:
> Is there a SQL query or a database parameter setting that I can use from
> an external application to determine if the PostgreSQL database is on
> cloud (like on Amazon RDS or IBM cloud) or on a non-cloud on-prem
> environment?
Here's my psqlrc file whi
> EDB or Aurora to Open source Postgres assuming we dont use AWS services OR
> would you suggest to move to Community version from the start by taking
> support/consultancy
> from other companies like 2nd quadrant and etc?
EDB is mainly attractive to Oracle shops who want Oracle compatibility.
Hi All,
In our company we are looking to migrate oracle db to postgres , now since
we dont have any expertise in Postgres in our organization so we are
planning to go
with AWS aurora or EDB postgres so that we have helping hand in
migration(in dev and dba) while we get mature in postgres ... do yo
On 5/8/19 3:42 AM, Prashant Hunnure wrote:
Dear Team,
I am working on postgres database version 9.3 is the part of opengeo
suite and now my running database become hacked by someone. In the
What makes you think it was hacked?
current situation I'm able to view my database under Pgadmin III
On 5/8/19 5:42 AM, Prashant Hunnure wrote:
Dear Team,
I am working on postgres database version 9.3 is the part of opengeo suite
and now my running database become hacked by someone. In the current
situation I'm able to view my database under Pgadmin III but unable to
view the tables, functio
> I am working on postgres database version 9.3
> ...and now my running database become hacked by someone.
imho:
The 9.3 version is End of Life (EoL) ;
Final Release:9.3.25 (November 8, 2018)
https://www.postgresql.org/support/versioning/
Please upgrade for newer versions ( with the latest
On 2019-May-07, Mitar wrote:
> On Mon, May 6, 2019 at 1:21 PM Tom Lane wrote:
> > There is not, and never has been, any claim that JSON numbers correspond
> > to the IEEE spec.
>
> There is note [1], but yes, it does not claim that nor I claimed that.
> I am just saying that the reality is that
Dear Team,
I am working on postgres database version 9.3 is the part of opengeo suite
and now my running database become hacked by someone. In the current
situation I'm able to view my database under Pgadmin III but unable to view
the tables, functions and other attributes on windows environment.
29 matches
Mail list logo
