Re: can't get psql authentication against Active Directory working

2023-02-24 Thread Stephen Frost
Greetings, * Tomas Pospisek (t...@sourcepole.ch) wrote: > again thanks a lot for trying to help me! Sure, would like to see it work for you. > On 21.02.23 16:29, Stephen Frost wrote: > > * Tomas Pospisek (t...@sourcepole.ch) wrote: > > > On 20.02.23 15:17, Stephen Frost wrote: > > > > * Tomas Po

Re: curiosity in default column header

2023-02-24 Thread David G. Johnston
On Fri, Feb 24, 2023 at 1:47 PM Rob Sargent wrote: > > Why is the last one headed "ascii" and not "bit"? > Because a function name is more likely to be a useful label than a data type. David J.

curiosity in default column header

2023-02-24 Thread Rob Sargent
riftehr=> select ascii(substring('sadb', 2,1));  ascii ---     97 (1 row) riftehr=> select 24::bit(8);    bit --  00011000 (1 row) riftehr=> select ascii(substring('sadb', 2,1))::bit(8);   ascii --  0111 (1 row) Why is the last one headed "ascii" and not "bit"?

Re: Debugging postgres on Windows - could not open directory "/lib"

2023-02-24 Thread Adrian Klaver
On 2/23/23 17:16, Cathy Xie wrote: On Thu, Feb 23, 2023 at 1:21 AM Adrian Klaver > wrote: On 2/21/23 17:18, Cathy Xie wrote: > > > On Wed, Feb 22, 2023 at 6:54 AM Adrian Klaver mailto:adrian.kla...@aklaver.com> > > Hi Adrian,

Re: PostgreSQL optimizations for CoW FS

2023-02-24 Thread Peter Eisentraut
On 22.02.23 10:41, HECTOR INGERTO wrote: Let’s say we have to run a PostgreSQL instance on top of a copy on write filesystem like ZFS or BTRFS. In adittion to set full_page_writes = off, what other optimizations can be done on the PostgreSQL side? Look at the settings wal_init_zero and wal_rec

Re: can't get psql authentication against Active Directory working

2023-02-24 Thread Tomas Pospisek
Hi Stephen, again thanks a lot for trying to help me! On 21.02.23 16:29, Stephen Frost wrote: * Tomas Pospisek (t...@sourcepole.ch) wrote: On 20.02.23 15:17, Stephen Frost wrote: * Tomas Pospisek (t...@sourcepole.ch) wrote: so I'm trying to authenticate psql (on Windows) -> postgres (on Lin