Hi Adrian,
thx for your answer. I checked all the relevant & installed packages:
hi postgis 3.0.2+dfsg-2.pgdg100+1
ii postgis-doc 3.0.2+dfsg-2.pgdg100+1
ii postgresql-12 12.4-1.pgdg100+1
ii postgresql-12-postgis-2.5 2
Hi,
I was setting up a master/slave pgsql(version 12.4) cluster using stream
replication. I found 3 ways to authenticate, but all of them has some security
issue.
1. Disable authentication.
cat pg_hba.conf
host all all0/0 md5
host replication xie
On Tue, Oct 27, 2020 at 9:52 AM xiebin (F) wrote:
> Hi,
>
>
>
> I was setting up a master/slave pgsql(version 12.4) cluster using stream
> replication. I found 3 ways to authenticate, but all of them has some
> security issue.
>
>
>
> 1. Disable authentication.
>
> *cat pg_hba.conf*
>
> *hos
Perhaps you misunderstand me.
It is not user-database, but master-slave interaction that I am concerning.
The master-slave replication proceeds continually and requires no manual
interference. Both master and slave’s private key are involved, but
ssl_passphrase_command is only used to parse pass
Hello everyone,
I'm currently in the process of upgrading our PostgreSQL installations
from 9.6 to 13. I am experiencing very slow query performance for empty
tables.
Our test environments get build from scratch every run, and thus contain
a lot of empty tables at first. We hit the issue dis
On Tue, Oct 27, 2020 at 12:34 PM xiebin (F) wrote:
> Perhaps you misunderstand me.
>
> It is not user-database, but master-slave interaction that I am
> concerning.
>
> The master-slave replication proceeds continually and requires no manual
> interference. Both master and slave’s private key ar
On Mon, 2020-10-26 at 10:45 +, Mahesh Bodepati wrote:
> i am facing the problem in passing the outparameters in postgres package
> calling by using c language
There are no "packages" in PostgreSQL.
Can you clarify your question?
How is the function or procedure you are calling defined?
Your
I know when I set it up with a password protecting the private key it would
prompt me for the password when I started up the service.
Susan Joseph
sandajos...@verizon.net
-Original Message-
From: xiebin (F)
To: Magnus Hagander
Cc: pgsql-gene...@postgresql.org ; zhubo (C)
; Zhuzh
Hello Tom,
Sorry to bump this conversation, but I'm still dealing with this issue.
I come back because I've found something different that throws away
all the hypotheses (or at least it's what I think).
I've run the automated script several times, and the duration of the
query is widely variable.
pgsql-general,
I'm turning to the the pgsql-general mailing list because I haven't found a
solution elsewhere on the internet. Thanks to all who can help.
I'm using pgadmin4 on a macOS system and I'm having trouble connecting to a
server of interest. The "Connect to Server" dialog box has a warni
Sean McDaniel writes:
> I'm using pgadmin4 on a macOS system and I'm having trouble connecting to a
> server of interest. The "Connect to Server" dialog box has a warning:
> "GSSAPI authentication not supported". I cannot proceed beyond that point.
> It seems to be a GSSAPI issue. I have postgres
> On Oct 27, 2020, at 12:23 PM, Tom Lane wrote:
>
> Sean McDaniel writes:
>> I'm using pgadmin4 on a macOS system and I'm having trouble connecting to a
>> server of interest. The "Connect to Server" dialog box has a warning:
>> "GSSAPI authentication not supported". I cannot proceed beyond tha
Neil writes:
> On Oct 27, 2020, at 12:23 PM, Tom Lane wrote:
>> A quick look through our source code finds that error string only in
>> libpq; it indicates that libpq was built without GSSAPI support.
> On my Mac pgadmin4 seems to use its own libpq.
> You can find it at: /Applications/pgAdmin\
=?UTF-8?Q?Eudald_Valc=C3=A0rcel_Lacasa?= writes:
> I've run the automated script several times, and the duration of the
> query is widely variable.
Interesting. You might try using auto_explain to log the query plans
and see if the plan is changing.
regards, tom lane
Hi,
I have high CPU utilization on my server, when I checked
pg_stat_activity , I found that I am attaching here as an attachment.
I am unbale to catch the actual cause.
Please help me in rectifying so that CPU consumption can be reduced.
Regards,
Atul
Thanks Tom and Neil.
What you've said makes sense. The pgadmin4 pibpq doesn't support GSSAPI.
I followed your suggestions and symlinked libpq.5.dylib under
/Applications/pgAdmin 4.app/Contents/Frameworks to the homebrew library
/usr/lib/libpq.5.6.dylib, but unfortunately pgadmin4 now fails on lau
Sean McDaniel writes:
> I followed your suggestions and symlinked libpq.5.dylib under
> /Applications/pgAdmin 4.app/Contents/Frameworks to the homebrew library
> /usr/lib/libpq.5.6.dylib, but unfortunately pgadmin4 now fails on launch
> with the error "The pgadmin4 server could not be contacted."
On Tue, Oct 27, 2020 at 6:14 AM Jurrie Overgoor <
postgresql-mailingl...@jurr.org> wrote:
> - I could turn off JIT in the server config, but I'd like to use the JIT
feature where it's appropriate!
I would do this, until PG14 and you can verify it works in most cases for
you. 9.6 to 13 is alread
On 10/26/20 10:53 PM, Hu Bert wrote:
Hi Adrian,
thx for your answer. I checked all the relevant & installed packages:
hi postgis 3.0.2+dfsg-2.pgdg100+1
ii postgis-doc 3.0.2+dfsg-2.pgdg100+1
ii postgresql-12 12.4-1.pgdg100+1
Hi,
A colleague is getting this error when trying to load a
database dump:
pg_restore: error: could not execute query: ERROR: schema "public" already
exists
I'm wondering if anyone can explain it.
Here's the background.
I have a "dump" script that calls pg_dump and pipes the
output into gp
raf writes:
> A colleague is getting this error when trying to load a
> database dump:
> pg_restore: error: could not execute query: ERROR: schema "public" already
> exists
> I'm wondering if anyone can explain it.
The public schema is a bit of a strange beast, and pg_dump has to
special-case
21 matches
Mail list logo
