data=writeback and safety of WAL files

Hi, The document states, that in case of ext3 filesystems, filesystem journaling can be configured with data=writeback option to increase performance (in specific cases). Per my understanding this causes some of the filesystem integrity me

Re: Postgres 9.3 service no longer starts on Windows 8.1

Obligatory "you need to upgrade!!!" comment: both Postgres 9.3 and Windows 8.1 are far beyond EOL. (Don't think I'm being high and mighty, since I still must maintain Pg 9.2 and SQL Server 2005, 2008, & 2008R2 servers...) On 1/26/21 8:51 PM, Lisa Ruby wrote: Don't know why this so often happ

Re: Postgres 9.3 service no longer starts on Windows 8.1

Don't know why this so often happens, but it does. I'll look for hours for a solution to a problem, finally give up and ask for help, and then find a solution. I just solved my problem. I started looking at permissions on the database location folders. Saw that NETWORK SERVICE had full security

Postgres 9.3 service no longer starts on Windows 8.1

I am using Postgres 9.3 on a Windows 8.1 computer. I've been using it for over 5 years on the same computer to provide a database for a local JIRA Server. I did a normal restart of my computer last night and ever since then the Postgres service fails to start. I am able to start Postgres from t

Re: Change work_mem for one user

Hello Tom Thank you very much for the quick response. I just realized the issue is caused by the tool, DataGrid, I am using. In DataGrid, when I close a tab, it does not actually disconnect from the database so it does not re-login when I open a new tab. Again. thank you for the help. On T

Re: Change work_mem for one user

Wenjun Che writes: > We are running pg 10.10 on AWS RDS. I want to increase work_mem for one > user with following command: > ALTER ROLE test_user SET work_mem TO '50 MB'; > After I run the command and log in as test_user, "show work_mem" still > shows the default 4MB. Hmm, works for me: regr

Change work_mem for one user

Hello We are running pg 10.10 on AWS RDS. I want to increase work_mem for one user with following command: ALTER ROLE test_user SET work_mem TO '50 MB'; After I run the command and log in as test_user, "show work_mem" still shows the default 4MB. Thank you -- Wenjun Che VP of Engineering

Re: How to keep format of views source code as entered?

Hi Ingolf, > On 26. Jan, 2021, at 14:41, Markhof, Ingolf > wrote: > > You may not be able to delete tables / views that are referenced by other > users objects, e.g. views. Unless you add the CASCADE option which will cause > all depending views to be deleted as well. And the CASCASE will wor

Re: How to keep format of views source code as entered?

Hi! Today, I made an astonishing / disappointing experience related to that source code topic: You may not be able to delete tables / views that are referenced by other users objects, e.g. views. Unless you add the CASCADE option which will cause all depending views to be deleted as well. And