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
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
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
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
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."
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
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
=?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
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\
> 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
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
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
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.
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
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
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
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
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
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
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
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
21 matches
Mail list logo
