Re: Help with restoring database from old version of PostgreSQL

2024-11-14 Thread Ron Johnson
1. PG16 will read a PG 9.6 backup file, so there's no need to install PG 9.6. 2. Installing PG on a OneDrive share is certainly a Very Bad Idea. 3. PG is not the same as PgAdmin. On Thu, Nov 14, 2024 at 10:00 AM Catherine Frock wrote: > Yes, I still have the backup file. I tried to open pgAdmin4

Re: question on audit columns

2024-11-14 Thread Greg Sabino Mullane
As far as the application being able to change those fields itself, you can prevent that via column permissions, by leaving out the four audit columns and doing something like: GRANT INSERT (email, widget_count), UPDATE (email, widget_count) ON TABLE foobar TO PUBLIC; That way, inserts are guaran

Re: postgresql-17.0-1 Application - silent installation Issue

2024-11-14 Thread Adrian Klaver
On 11/14/24 01:05, JOLAPARA Urvi (SAFRAN) wrote: C2 - Confidential Hello Klaver, I have added below the log where setup is failing on FR language machine. Log started 11/14/2024 at 09:04:33 Preferred installation mode : unattended Trying to init installer in mode unattended Mode unattended suc

Re: Help with restoring database from old version of PostgreSQL

2024-11-14 Thread Adrian Klaver
On 11/14/24 07:00, Catherine Frock wrote: Yes, I still have the backup file. I tried to open pgAdmin4 today to see what version I'm running, and now this happened (see attachments). My operating system is Windows 10 Home, version 10.0.19045 Build 19045. I installed Postgres using these instruct

Re: postgresql-17.0-1 Application - silent installation Issue

2024-11-14 Thread Rob Sargent
> > Please transfer the request who works with windows. We need the solution asap. > > Thanks & Regards, > Urvi Jolapara > urvi.jolap...@safrangroup.com > If a windows admin/user shows up they may be better able to help. There is no one to "transfer" to. The list of missing keys suggests t

Re: work_mem RAM Accounting in PostgreSQL

2024-11-14 Thread Laurenz Albe
On Wed, 2024-11-13 at 21:09 +0200, Alexandru Lazarev wrote: > I have some questions regarding how the "work_mem" parameter affects the > overall RAM > usage of PostgreSQL processes within a physical host or container. > > Each backend process during SQL execution may allocate N * "work_mem" > si

RE: postgresql-17.0-1 Application - silent installation Issue

2024-11-14 Thread JOLAPARA Urvi (SAFRAN)
C2 - Confidential Hello Klaver, I have added below the log where setup is failing on FR language machine. Log started 11/14/2024 at 09:04:33 Preferred installation mode : unattended Trying to init installer in mode unattended Mode unattended successfully initialized Setting variable whoami from

Re: DB wal file disabled --_Query

2024-11-14 Thread David G. Johnston
On Thursday, November 14, 2024, jayakumar s wrote: > > Archive mode is already disabled. If more wal files will generate fs also > reached 100 percent based on application data load. > > As updated archive enabled or disabled. Will any state wall file that > will be generate correct? > WAL files

Re: Row level security policy

2024-11-14 Thread Mark Phillips
Thank you for clarifying this. I missed that even though it is there in the second paragraph. - Mark, out and about. > On Nov 14, 2024, at 1:57 AM, Laurenz Albe wrote: > > On Wed, 2024-11-13 at 17:33 -0800, Mark Phillips wrote: >> Given a database table with one policy statement FOR SELECT ap

Re: Row level security policy

2024-11-14 Thread Laurenz Albe
On Wed, 2024-11-13 at 17:33 -0800, Mark Phillips wrote: > Given a database table with one policy statement FOR SELECT applied, it is > necessary > to apply additional policy statements for insert, update, and delete > operations? > > My testing indicates that this is case but I haven’t found an

Re: DB wal file disabled --_Query

2024-11-14 Thread jayakumar s
Hi All, Archive mode is already disabled. If more wal files will generate fs also reached 100 percent based on application data load. As updated archive enabled or disabled. Will any state wall file that will be generate correct? On Wed, Nov 13, 2024 at 9:54 PM Adrian Klaver wrote: > On 11/13/

Re: question on audit columns

2024-11-14 Thread Johannes Lochmann
... and (3) the values are not updated on manual actions without triggers - which might or might not be desirable depending on the intention. Best, Johannes On 9/4/2024 16:36, Adrian Klaver wrote: On 9/4/24 06:17, Khan Muhammad Usman wrote: Yes this would be the better approach. 1) Except

Retrieve filename within a script

2024-11-14 Thread Patrick FICHE
Hi, I was wondering if it was possible to get the filename provided as an argument to psql. psql -f /tmp/test.sql I would like a command in test.sql that would be able to retrieve the full pathname (/tmp/test.sql). Regards, Patrick