Re: Errors after cloning OS to new disk under Hyper-V

writes: > From: Rob Sargent >> Have you tried to REINDEX as suggested? > I cannot get access to psql. If there is a way to reindex without having to > login first, I do not know how to do that. The disaster recovery process that Rob is suggesting goes like this: * Shut down server, if it's

Re: Errors after cloning OS to new disk under Hyper-V

so 18. 7. 2020 v 6:36 odesílatel napsal: > -Original Message- > From: Rob Sargent > Sent: Saturday, July 18, 2020 5:56 AM > To: pgsql-general@lists.postgresql.org > Subject: Re: Errors after cloning OS to new disk under Hyper-V > > > Have you tried to REINDEX as suggested? > > I cannot

RE: Errors after cloning OS to new disk under Hyper-V

-Original Message- From: Rob Sargent Sent: Saturday, July 18, 2020 5:56 AM To: pgsql-general@lists.postgresql.org Subject: Re: Errors after cloning OS to new disk under Hyper-V > Have you tried to REINDEX as suggested? I cannot get access to psql. If there is a way to reindex without

Re: Errors after cloning OS to new disk under Hyper-V

On 7/17/20 8:51 PM, ertan.kucuko...@1nar.com.tr wrote: Hello, This is PostgreSQL v10.10 64Bit, running on Windows 10 64Bit. One user, by himself, without asking for help, cloned his OS from one disk to Hyper-V disk. Old disk was not accessed, OS was shutdown while he is doing the cloning.

Errors after cloning OS to new disk under Hyper-V

Hello, This is PostgreSQL v10.10 64Bit, running on Windows 10 64Bit. One user, by himself, without asking for help, cloned his OS from one disk to Hyper-V disk. Old disk was not accessed, OS was shutdown while he is doing the cloning. He used some kind of tool that I do not know for that

Re: About compress in pg_dump

On 7/17/20 8:12 AM, Diego wrote: Yep, I transfer backups files all the time with -Fc and never the problem was rsync Using --rsyncable with gzip really helps if you rsync the compressed file to somewhere else it exists. It greatly reduces the amount of data sent for files that a do not have

Re: About compress in pg_dump

On 7/17/20 7:48 AM, Edmundo Robles wrote: To backup  a database  I do:  nice -n +19  pg_dump -Fc  database | nice -n +19 gzip --rsyncable -nc >  database.dump If -Fc  option  is compressed  by default  I dont need gzip the backup, but I need pass --rsyncable  and -n options. How can  I

Re: python async with psycopg2

On Fri, 17 Jul 2020 at 20:44, Rita wrote:> > curs = conn.cursor() > curs.execute("LISTEN mychan0;") > #curs.execute("LISTEN mychan1;") #fails! > wait_select(conn) Maybe you have to wait_select after each execute. This example could be helpful.

python async with psycopg2

I am trying to listen to multiple channels thru pg_notify mechanism. select pg_notify('mychan0',foo'); select pg_notify('mychan'1,'bar'); In python I have something like this import select,time import psycopg2 import psycopg2.extensions from psycopg2.extras import wait_select DSN="dbname=mydb

DB Authentication with Label Security

Oracle has a product called Oracle Label Security using Oracle Internet Directory. Does PostgreSQL have a similar capability? Thank you in advance!

Re: PostgreSQL make too long to start.

On Fri, Jul 17, 2020 at 9:16 AM FOUTE K. Jaurès wrote: > It is make sense that PostgreSQL make too long to start, About 20 > minutes. I'm using PostgreSQL 12 intalling on Ubuntu Server 18.04 and my > database is about 25 GO of data. > Every time? How are you shutting down the server?

PostgreSQL make too long to start.

It is make sense that PostgreSQL make too long to start, About 20 minutes. I'm using PostgreSQL 12 intalling on Ubuntu Server 18.04 and my database is about 25 GO of data.

Re: Security Vulnerability on PostgreSQL VMs

On Fri, Jul 17, 2020 at 5:44 PM Hilbert, Karin wrote: > We have PostgreSQL v9.6 & also PostgreSQL v11.8 installed on various Linux > VMs with Red Hat Enterprise Linux Server release 7.8 (Maipo) OS. We're > also running repmgr v5.1.0 & PgBouncer v1.13. > > We're getting vulnerability reports

Re: Security Vulnerability on PostgreSQL VMs

Hi! Try with "yum deplist " to check who app use phyton. Diego, On 2020-07-17 12:44, Hilbert, Karin wrote: We have PostgreSQL v9.6 & also PostgreSQL v11.8 installed on various Linux VMs with Red Hat Enterprise Linux Server release 7.8 (Maipo) OS.  We're also running repmgr v5.1.0 &

Re: Security Vulnerability on PostgreSQL VMs

There has to be some "yum" or "rpm" option to show what depends on those packages. On 7/17/20 10:44 AM, Hilbert, Karin wrote: We have PostgreSQL v9.6 & also PostgreSQL v11.8 installed on various Linux VMs with Red Hat Enterprise Linux Server release 7.8 (Maipo) OS.  We're also running repmgr

Security Vulnerability on PostgreSQL VMs

We have PostgreSQL v9.6 & also PostgreSQL v11.8 installed on various Linux VMs with Red Hat Enterprise Linux Server release 7.8 (Maipo) OS. We're also running repmgr v5.1.0 & PgBouncer v1.13. We're getting vulnerability reports from our Security Office for the following packages: -

Re: About compress in pg_dump

Yep, I transfer backups files all the time with -Fc and never the problem was rsync On 2020-07-17 12:07, David G. Johnston wrote: On Fri, Jul 17, 2020 at 7:49 AM Edmundo Robles > wrote: To backup  a database  I do:  nice -n +19  pg_dump -Fc  database |

Re: About compress in pg_dump

On Fri, Jul 17, 2020 at 7:49 AM Edmundo Robles wrote: > To backup a database I do: > nice -n +19 pg_dump -Fc database | nice -n +19 gzip --rsyncable -nc > > database.dump > > If -Fc option is compressed by default I dont need gzip the backup, > but I need pass --rsyncable and -n

About compress in pg_dump

To backup a database I do: nice -n +19 pg_dump -Fc database | nice -n +19 gzip --rsyncable -nc > database.dump If -Fc option is compressed by default I dont need gzip the backup, but I need pass --rsyncable and -n options. How can I pass gzip options to compress in pg_dump? if

Re: Where Do I Find...

Hi Gene, > On 17. Jul, 2020, at 16:05, Eugene Poole wrote: > > I need to know if there is any documentation on what has to be changed in my > Oracle DDL so that it works in PgSql and this includes data inserts. not in general, that I know of. It depends on your Oracle DDL. If you are

Where Do I Find...

I need to know if there is any documentation on what has to be changed in my Oracle DDL so that it works in PgSql and this includes data inserts. Gene

Re: Capturing just slow queries

Thank you for the information. That's a comprehensive list of monitoring solutions. I'll take a look. Tiff On Fri, Jul 17, 2020 at 4:14 AM Wim Bertels wrote: > You might have a look at: > https://www.postgresql.org/docs/current/auto-explain.html > > Also there are several monitoring solutions:

Re: Capturing just slow queries

You might have a look at: https://www.postgresql.org/docs/current/auto-explain.html Also there are several monitoring solutions: https://wiki.postgresql.org/wiki/Monitoring Tiffany Thang schreef op do 16-07-2020 om 13:41 [-0400]: > Hi, > log_min_duration_statement captures all statements