Bug - 11.8 - Mailing list pgsql-bugs

From Panchal, Avanish
Subject Bug - 11.8
Date
Msg-id DM6PR05MB71618BF667B9FA77A8F5ADC8EC780@DM6PR05MB7161.namprd05.prod.outlook.com
Whole thread Raw
Responses Re: Bug - 11.8
List pgsql-bugs

Hi,

 

While installing postgre11.8 with ./configure, followed by make install.

 

Commands:

 

./configure –prefix= /pghome/11.8

 

make -j 4 && make install

 

Ran into 2 issues

 

  1. postgresql.service not present in systemd.

 

-bash-4.2$ sudo ls -ltr /usr/lib/systemd/system/postgres*
ls: cannot access /usr/lib/systemd/system/postgres*: No such file or directory

 

Also realized, code was complied with "with_systemd='no'. Potential reason of file not present in system.

 

Found rc file:  /pgbackup/postgresql-11.8/contrib/start-scripts and try to edit postgresql.service with respective paths per install.

 

  1. postgresql-11-check-db-dir not present

Apparently bin directory doesn’t have postgresql-11-check-db-dir so unable to put it at ExecStartPre=/pghome/11.8/bin/postgresql-11-check-db-dir ${PGDATA}

 

Please let me know if any steps missed.

 

Regards,

 

Avanish Panchal

 



________________________________________
IMPORTANT - PLEASE READ: This electronic message, including its attachments, is CONFIDENTIAL and may contain PROPRIETARY or LEGALLY PRIVILEGED or PROTECTED information and is intended for the authorized recipient of the sender. If you are not the intended recipient, you are hereby notified that any use, disclosure, copying, or distribution of this message or any of the information included in it is unauthorized and strictly prohibited. If you have received this message in error, please immediately notify the sender by reply e-mail and permanently delete this message and its attachments, along with any copies thereof, from all locations received (e.g., computer, mobile device, etc.). To the extent permitted by law, we may monitor electronic communications for the purposes of ensuring compliance with our legal and regulatory obligations and internal policies. We may also collect email traffic headers for analyzing patterns of network traffic and managing client relationships. For further information see: https://www.iqvia.com/about-us/privacy/privacy-policy. Thank you.

pgsql-bugs by date:

Previous
From: Juan José Santamaría Flecha
Date:
Subject: Re: pg_dump's "--exclude-table" and "--exclude-table-data" options are ignored and/or cause the dump to fail entirely unless both the schema and table name use 1950s-era identifiers.
Next
From: PG Bug reporting form
Date:
Subject: BUG #16548: Order by on array element giving disparity in result