Re: Dropping all tables in a database

2023-08-07 Thread H
On 08/06/2023 09:24 PM, Christophe Pettus wrote: > >> On Aug 6, 2023, at 18:17, H wrote: >> >> Is there some setting I have to change in the database to have the first SQL >> statement to work or have I run into a possible bug? > The first statement just generates a line of text output that conta

Re: DB Server slow down & hang during Peak hours of Usage

2023-08-07 Thread Ron
On 8/7/23 08:41, KK CHN wrote: List , *Description:* Maintaining a DB Server Postgres and with a lot of read writes to this Server( virtual machine running on  ESXi 7 with CentOS 7) . ( I am not sure how to get the read / write counts or required IOPS or any other parameters for you. If  yo

DB Server slow down & hang during Peak hours of Usage

2023-08-07 Thread KK CHN
List , *Description:* Maintaining a DB Server Postgres and with a lot of read writes to this Server( virtual machine running on ESXi 7 with CentOS 7) . ( I am not sure how to get the read / write counts or required IOPS or any other parameters for you. If you point our I can execute those com

Re: Backup Copy of a Production server.

2023-08-07 Thread Ron
On 8/7/23 07:05, KK CHN wrote: On Mon, Aug 7, 2023 at 10:49 AM Ron wrote: On 8/7/23 00:02, KK CHN wrote: List, I am in need to copy a production PostgreSQL server  data( 1 TB)  to  an external storage( Say USB Hard Drive) and need to set up a backup server with this data

Re: Backup Copy of a Production server.

2023-08-07 Thread Chris Travers
On Mon, Aug 7, 2023 at 7:00 PM KK CHN wrote: > > > On Mon, Aug 7, 2023 at 10:49 AM Ron wrote: > >> On 8/7/23 00:02, KK CHN wrote: >> >> List, >> >> I am in need to copy a production PostgreSQL server data( 1 TB) to an >> external storage( Say USB Hard Drive) and need to set up a backup server

Re: My 1st TABLESPACE

2023-08-07 Thread Amn Ojee Uw
Thanks Negora. Makes sense, I will check it out. On 8/7/23 1:48 a.m., negora wrote: Hi: Although the "postgres" user owns the "data" directory, Has he access to the whole branch of directories? Maybe the problem is that he can't reach the "data" directory. Regards. On 07/08/2023 07:43,

Re: Backup Copy of a Production server.

2023-08-07 Thread KK CHN
On Mon, Aug 7, 2023 at 10:49 AM Ron wrote: > On 8/7/23 00:02, KK CHN wrote: > > List, > > I am in need to copy a production PostgreSQL server data( 1 TB) to an > external storage( Say USB Hard Drive) and need to set up a backup server > with this data dir. > > What is the trivial method to ach

Re:How to solve the warning?

2023-08-07 Thread Wen Yi
Hi, I check the image you send, I think you pass on a incompatible pointer: The PostgreSQL want you to pass on a 'List*' but you give a  'Node*'. And please send plain text next time, the PostgreSQL community archieve always just store the patch & plain text. Yours, Wen Yi --

[Question] Can someone provide the explain of the relation between PGPROC and transaction?

2023-08-07 Thread Wen Yi
Hi Community! I have already read the comment of the proc.h, read some related question about it, and read the "74. Transaction Processing" of the PostgreSQL document. But I really don't know how the PGPROC works in the transcation? Can someone provide me some help? Thanks in advance! Yours, W