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 a
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)
pgsqld
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 production
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
> with the public schéma :
>
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 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 another Dell PC with Win 10 Pro about 4 months
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 have *storage* failu
On Mon, Apr 23, 2018 at 12:47 PM, Alexander Farber <
alexander.far...@gmail.com> wrote:
> SELECT
> u.elo,
> AVG(c.played - c.prev_played) AS avg_time_per_move,
> (SELECT ROUND(AVG(score), 1) FROM words_moves
>
Good evening,
On Mon, Apr 23, 2018 at 12:56 PM, Alexander Farber <
alexander.far...@gmail.com> wrote:
>
> On Mon, Apr 23, 2018 at 12:15 PM, Daniel Verite
> wrote:
>
>>
>> You may use a correlated subquery in the SELECT clause,
>>
>
>SELECT
> u.elo,
>
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 to
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
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 pat
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
applicati
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
cr
On system hard drive search for the file called
bitrock_installer_.log.
You should find it in Users\\AppData\Local\Temp.
This log should provide you with more specific details explaining why data
folder is empty.
Regards,
Igor
From: Dale Seaburg [mailto:kg...@verizon.net]
Sent: Saturday, April
Thank you, Daniel -
On Mon, Apr 23, 2018 at 12:15 PM, Daniel Verite
wrote:
>
> You may use a correlated subquery in the SELECT clause,
> like this:
>
> SELECT
>u.elo,
>u.uid,
>(SELECT AVG(score) FROM words_moves WHERE uid=u.uid),
>s.given,
>s.photo
>
thi
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
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 (sto
18 matches
Mail list logo
