Re: solved (was plain stupidity) Re: ubuntu 18: PostgreSQL does not start. how can I totally remove and reinstall it

Hi Robert, > On 24. Jan, 2021, at 08:13, robert rottermann wrote: > > thanks a lot. > why dos such stupidity not hurt. ? the human brain does not contain pain generating or transmitting nerve cells, that's why. :-P Cheers, Paul

Re: Need help with trigger

On 23-01-2021 23:29, Melvin Davidson wrote: Maybe this example will help. From https://www.postgresql.org/docs/current/sql-insert.html INSERT INTO distributors AS d (did, dname) VALUES (8, 'Anvil Distribution') ON CONFLICT (did) DO UPDATE SET dname = EXCLUDED.dname || ' (formerly ' || d.

Re: solved (was plain stupidity) Re: ubuntu 18: PostgreSQL does not start. how can I totally remove and reinstall it

Robert, Otherwise mankind would constantly be in pain ;-) Enjoy the weekend ! Marc On 24 Jan 2021, at 8:13, robert rottermann wrote: thanks a lot. why dos such stupidity not hurt. ? have a nice weekend robert On 24.01.21 08:04, Julien Rouhaud wrote: On Sun, Jan 24, 2021 at 2:58 PM rob

Re: ubuntu 18: PostgreSQL does not start. how can I totally remove and reinstall it

On 1/23/21 11:08 PM, Hemil Ruparel wrote: One small note. Aside from the fact that your server is running from a different port, psycopg2 does not support authentication without password afaik. It has bit me twice You will need to explain that further as I have not seen that over many years u

Re: ubuntu 18: PostgreSQL does not start. how can I totally remove and reinstall it

On Sun, 24 Jan 2021 at 08:09, Hemil Ruparel wrote: > > One small note. Aside from the fact that your server is running from a > different port, psycopg2 does not support authentication without password > afaik. It has bit me twice It is more likely that you have some misunderstanding around Pos

Re: ubuntu 18: PostgreSQL does not start. how can I totally remove and reinstall it

On 1/23/21 11:08 PM, Hemil Ruparel wrote: One small note. Aside from the fact that your server is running from a different port, psycopg2 does not support authentication without password afaik. It has bit me twice Some thinking on this made me realize where you could get into this situation.

CLUSTER, VACUUM, and TABLESPACEs (oh my)

Hi, I would like to request a little clarification on the CLUSTER and VACUUM commands. My use case here (partially) is when my disk runs out of space and I want to move a table to a newly created tablespace. These questions somewhat overlap. Let’s say I am starting with a table that is not CLUS

Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)

Hi, Le lun. 25 janv. 2021 à 01:38, Demitri Muna a écrit : > Hi, > > I would like to request a little clarification on the CLUSTER and VACUUM > commands. My use case here (partially) is when my disk runs out of space > and I want to move a table to a newly created tablespace. These questions > so

Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)

On 1/24/21 7:50 PM, Guillaume Lelarge wrote: Hi, Le lun. 25 janv. 2021 à 01:38, Demitri Muna > a écrit : [snip] * If I have previously run a CLUSTER command on a table, will future VACUUM FULL commands rewrite the table in the order specified in the

Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)

Le lun. 25 janv. 2021 à 02:54, Ron a écrit : > On 1/24/21 7:50 PM, Guillaume Lelarge wrote: > > Hi, > > Le lun. 25 janv. 2021 à 01:38, Demitri Muna a > écrit : > > [snip] > > >> * If I have previously run a CLUSTER command on a table, will future >> VACUUM FULL commands rewrite the table in the

Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)

> On Jan 24, 2021, at 9:03 PM, Guillaume Lelarge wrote: > >> VACUUM FULL unclusters the table?? > > It will rebuild the table without sorting the data according to the index > used with CLUSTER (without any sorting actually). Thank you for the clarification; that’s very helpful. For the case

Can I use Postgres rules to reset session variables before/after queries?

I am using Postgres row level security and I wish to ensure it is not possible for a specific session variable (that holds a tenant id) to remain set in between transactions / queries. The reason is because this is a web application that pools sessions and the session is shared between user web qu

Re: Can I use Postgres rules to reset session variables before/after queries?

> On Jan 24, 2021, at 21:00, Andrew Stuart wrote: > Can anyone suggest if session variables can be SET/RESET using Postgres > rules, or optionally perhaps there is a better way to do so? PostgreSQL poolers generally use the RESET ALL command when reassigning a session to clear the session st

Re: Can I use Postgres rules to reset session variables before/after queries?

Christophe Pettus writes: >> On Jan 24, 2021, at 21:00, Andrew Stuart wrote: >> Can anyone suggest if session variables can be SET/RESET using Postgres >> rules, or optionally perhaps there is a better way to do so? > PostgreSQL poolers generally use the RESET ALL command when reassigning a >

Re: CLUSTER, VACUUM, and TABLESPACEs (oh my)

Le lun. 25 janv. 2021 à 03:27, Demitri Muna a écrit : > > > On Jan 24, 2021, at 9:03 PM, Guillaume Lelarge > wrote: > > > >> VACUUM FULL unclusters the table?? > > > > It will rebuild the table without sorting the data according to the > index used with CLUSTER (without any sorting actually). >