Re: collect2: error: ld returned 1 exit status

2022-11-26 Thread William Torrez Corea
On Sat, Nov 26, 2022 at 7:55 PM Rob Sargent wrote: > > header files for libpq5 (PostgreSQL library), the package is broken. > -- > > With kindest regards, William. > > ⢀⣴⠾⠻⢶⣦⠀ > ⣾⠁⢠⠒⠀⣿⡁ Debian - The universal operating system > ⢿⡄⠘⠷⠚⠋⠀ https://www.debian.org > ⠈⠳⣄ > > > I’m confused. Is that

Re: collect2: error: ld returned 1 exit status

2022-11-26 Thread Rob Sargent
header files for libpq5 (PostgreSQL library), the package is broken. -- With kindest regards, William.⢀⣴⠾⠻⢶⣦⠀ ⣾⠁⢠⠒⠀⣿⡁ Debian - The universal operating system⢿⡄⠘⠷⠚⠋⠀ https://www.debian.org⠈⠳⣄ I’m confused. Is that  ‘package is broken’ coming from dpkg. 

Re: collect2: error: ld returned 1 exit status

2022-11-26 Thread William Torrez Corea
On Sat, Nov 26, 2022 at 5:25 PM Rob Sargent wrote: > > On Nov 26, 2022, at 4:17 PM, William Torrez Corea > wrote: > >  > > > On Sat, Nov 26, 2022 at 5:00 PM Rob Sargent wrote: > >> >> >> On Nov 26, 2022, at 3:43 PM, William Torrez Corea >> wrote: >> >>  >> I am using libpq: the C application

Re: collect2: error: ld returned 1 exit status

2022-11-26 Thread Tom Lane
William Torrez Corea writes: > On Sat, Nov 26, 2022 at 5:00 PM Rob Sargent wrote: >> On Nov 26, 2022, at 3:43 PM, William Torrez Corea >> wrote: >>> Compile the code: >>> *sudo cc -o testprog testprog1.o testprog2.o -L/usr/local/pgsql/lib -lpq* >>> But i get the following error: >>> *collect2: e

Re: collect2: error: ld returned 1 exit status

2022-11-26 Thread Rob Sargent
On Nov 26, 2022, at 4:17 PM, William Torrez Corea wrote:On Sat, Nov 26, 2022 at 5:00 PM Rob Sargent wrote:On Nov 26, 2022, at 3:43 PM, William Torrez Corea wrote:I am using libpq: the C application programmer's interface to PostgreSQL. Compile the

Re: collect2: error: ld returned 1 exit status

2022-11-26 Thread William Torrez Corea
On Sat, Nov 26, 2022 at 5:00 PM Rob Sargent wrote: > > > On Nov 26, 2022, at 3:43 PM, William Torrez Corea > wrote: > >  > I am using libpq: the C application programmer's interface to PostgreSQL. > > Compile the code: > > >> *sudo cc -o testprog testprog1.o testprog2.o -L/usr/local/pgsql/lib -

Re: collect2: error: ld returned 1 exit status

2022-11-26 Thread Rob Sargent
> On Nov 26, 2022, at 3:43 PM, William Torrez Corea > wrote: > >  > I am using libpq: the C application programmer's interface to PostgreSQL. > > Compile the code: > >> sudo cc -o testprog testprog1.o testprog2.o -L/usr/local/pgsql/lib -lpq > > But i get the following error: > >> collect

collect2: error: ld returned 1 exit status

2022-11-26 Thread William Torrez Corea
I am using libpq: the C application programmer's interface to PostgreSQL. Compile the code: > *sudo cc -o testprog testprog1.o testprog2.o -L/usr/local/pgsql/lib -lpq* > But i get the following error: *collect2: error: ld returned 1 exit status* > -- With kindest regards, William. ⢀⣴⠾⠻⢶⣦⠀

WAL contains references to invalid pages in hot standby

2022-11-26 Thread Andrus
Hi! WAL playback in hot standby server crashes  with "WAL contains references to invalid pages" error : 2022-11-26 17:48:12.889 EET [497] LOG:  restored log file "000105790064" from archive 2022-11-26 17:48:20.897 EET [497] LOG:  restored log file "000105790065" from

Re: system variable can be edited by all user?

2022-11-26 Thread Pierre Forstmann
Hello, You ccan try to use my extension pg_set_acl: https://github.com/pierreforstmann/pg_set_acl Le mar. 22 nov. 2022 à 09:07, chris navarroza a écrit : > Hi, > > Ive created a read only user (SELECT PRIVILEGE) but it turns out that this > user can do this queries: SHOW work_mem; SET work_mem