Re: Strange error in Windows 10 Pro

On 04/23/2018 07:09 PM, Dale Seaburg wrote: Thanks to Moreno and Igor for the Event Viewer suggestions.  Here are a few lines of log file where they differ between a good install and a bad incomplete install.  The good install was from my Shop PC with Windows 10 Pro. BTW, I had success with

Postgres PAF setup

I am having issues with my PAF setup. I am new to Postgres and have setup the cluster as seen below. I am getting this error when trying to start my cluster resources. Master/Slave Set: pgsql-ha [pgsqld] pgsqld (ocf::heartbeat:pgsqlms): FAILED dcmilphlum224 (unmanaged)

rh-postgresql96 vs community postgresql-9.6

Our client has provided us Red Hat machine for setting up PostgreSQL. We are allowed to install red hat provided packages only. So we have to install red hat provided postgresql (rh-postgresql96) instead of postgresql-9.6. Is it a good approach to go with red hat specific PostgreSQL in

Re: Using the public schema

Erratum : The main problem with the public schéma is the default privileges (*create*) granted to all users able to connect. Le lun. 23 avr. 2018 à 21:16, Thomas Poty a écrit : > Hi charlin, > I invite you to read this doc it explains very well the security issue >

Re: Strange error in Windows 10 Pro

As you may have noticed in the Bad Install section, the user's name was 'don king' - with an embedded space.  I created a new user 'Dale' to test out whether that name might be causing a problem.  The new name also failed to complete an install. Dale On 4/23/2018 9:09 PM, Dale Seaburg

Re: Strange error in Windows 10 Pro

Thanks to Moreno and Igor for the Event Viewer suggestions.  Here are a few lines of log file where they differ between a good install and a bad incomplete install.  The good install was from my Shop PC with Windows 10 Pro. BTW, I had success with another Dell PC with Win 10 Pro about 4

Re: Postgres and fsync

Andres Freund writes: > Hi, > > On 2018-04-23 08:30:25 +1000, Tim Cross wrote: >> the recent article in LWN regarding issues with fsync and error >> reporting in the Linux kernel and the potential for lost data has >> prompted me to ask 2 questions. > > Note that you need to

Re: Using the public schema

Hi charlin, I invite you to read this doc it explains very well the security issue with the public schéma : https://wiki.postgresql.org/wiki/A_Guide_to_CVE-2018-1058:_Protect_Your_Search_Path The main problem with the public schéma is the default privileges (execute) granted to all users able

Re: Rationale for aversion to the central database?

So far, I have nothing to add, but just one thing. See below: On 09.04.2018 00:37, g...@luxsci.net wrote: One advantage to using logic and functions in  the db is that you can fix things immediately without having to make new application builds. That in itself is a huge advantage, IMO. This

Using the public schema

Hi, We will be developing three new applications in PostgreSQL, each having its own database instance running on different hosts. We will only have one schema per Postgres instance. The data is read-write only by one application/schema in the DB instance and the data is published to other

Re: Strange error in Windows 10 Pro

Il 21/04/2018 22:35, Adrian Klaver ha scritto: On 04/21/2018 01:08 PM, Dale Seaburg wrote: Thanks Adrian for the suggestion of running the installer with Admin rights.  Unfortunately, I get the same results.  It appears that all of the folders within C:\Program Files\PostgreSQL\9.6 path are

Re: Adding AVG to a JOIN

Alexander Farber wrote: > Here is such a query for the best player > > # SELECT AVG(score) FROM words_moves WHERE uid = 1201; > avg > - > 18.4803525523319868 > > However I am not sure, how to "marry" the 2 queries? > > I have tried to add words_moves through

Adding AVG to a JOIN

Hello, in PostgreSQL 10.3 I run the following query to find top 10 players with the best ELO rating: # SELECT u.elo, u.uid, s.given, s.photo FROM words_users u JOIN words_social s USING (uid) WHERE u.elo > 1500 -- take the most recent record from words_social