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
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
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
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
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
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,
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
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
--
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