Re: [GENERAL] cluster question

2017-08-13 Thread Andreas Kretschmer
On 14 August 2017 08:39:54 GMT+02:00, Alex Samad wrote: >Hi > >I have setup a streaming replicating cluster, with a hot standby. > >Now I would like to change the RW to hot standby and change the hot >standby >to be the RW server. > >Is it just a matter of updating recover.conf file ? > >Alex I w

[GENERAL] cluster question

2017-08-13 Thread Alex Samad
Hi I have setup a streaming replicating cluster, with a hot standby. Now I would like to change the RW to hot standby and change the hot standby to be the RW server. Is it just a matter of updating recover.conf file ? Alex

Re: [GENERAL] Help on Index only scan

2017-08-13 Thread Tom Lane
=?utf-8?Q?Ertan_K=C3=BC=C3=A7=C3=BCko=C4=9Flu?= writes: >>> I want to have an index only scan for my below query: >>> select autoinc, fileversion from updates where filename = 'Robox.exe' order >>> by autoinc desc; >> On 14 Aug 2017, at 01:15, Melvin Davidson wrote: >> As far as "Index only sca

Re: [GENERAL] Help on Index only scan

2017-08-13 Thread Melvin Davidson
On Sun, Aug 13, 2017 at 7:37 PM, Ertan Küçükoğlu < ertan.kucuko...@1nar.com.tr> wrote: > > On 14 Aug 2017, at 01:15, Melvin Davidson wrote: > > > On Sun, Aug 13, 2017 at 5:59 PM, Ertan Küçükoğlu < > ertan.kucuko...@1nar.com.tr> wrote: > >> Hello, >> >> My table details: >> robox=# \dS+ updates >>

Re: [GENERAL] Help on Index only scan

2017-08-13 Thread Ertan Küçükoğlu
> On 14 Aug 2017, at 01:15, Melvin Davidson wrote: > > >> On Sun, Aug 13, 2017 at 5:59 PM, Ertan Küçükoğlu >> wrote: >> Hello, >> >> My table details: >> robox=# \dS+ updates >>Table "public.updates" >> Column | Type |

Re: [GENERAL] Help on Index only scan

2017-08-13 Thread Melvin Davidson
On Sun, Aug 13, 2017 at 5:59 PM, Ertan Küçükoğlu < ertan.kucuko...@1nar.com.tr> wrote: > Hello, > > My table details: > robox=# \dS+ updates >Table "public.updates" > Column | Type | Modifiers > | Storage | Sta

[GENERAL] Help on Index only scan

2017-08-13 Thread Ertan Küçükoğlu
Hello, My table details: robox=# \dS+ updates Table "public.updates" Column | Type | Modifiers | Storage | Stats target | Description ---+-+--

Re: [GENERAL] Where is pg_hba.conf

2017-08-13 Thread George Neuner
On Sun, 13 Aug 2017 10:55:00 -0400, Igor Korot wrote: >Also, I presume that the address in this file is the address of the >machine where the server is located, not the address from where the >connection is initiated. No. The addresses / network segments in the file specify from where the clien

Re: [GENERAL] Where is pg_hba.conf

2017-08-13 Thread David G. Johnston
On Sunday, August 13, 2017, Igor Korot wrote: > Also, I presume that the address in this file is the address of the > machine where the server is located, not the address from where the > connection is initiated. > Not according to the docs. https://www.postgresql.org/docs/current/static/auth-p

Re: [GENERAL] Where is pg_hba.conf

2017-08-13 Thread Igor Korot
Also, I presume that the address in this file is the address of the machine where the server is located, not the address from where the connection is initiated. On Sun, Aug 13, 2017 at 10:53 AM, Igor Korot wrote: > Hi, > OK, I found it under the root account. > > Now I am modifying it as follows

Re: [GENERAL] Where is pg_hba.conf

2017-08-13 Thread Igor Korot
Hi, OK, I found it under the root account. Now I am modifying it as follows: # TYPE DATABASEUSERADDRESS METHOD # "local" is for Unix domain socket connections only local all all md5 # IPv4 local connections: h

Re: [GENERAL] Where is pg_hba.conf

2017-08-13 Thread Christoph Berg
Re: Igor Korot 2017-08-13 > draft=# SHOW hba_file > draft-# SHOW hba_file; > ERROR: syntax error at or near "SHOW" > LINE 2: SHOW hba_file; > ^ Standard beginners error. If you forgot the ";" on the first line, it'll process both lines as a single, erroneous command. Note the "

Re: [GENERAL] Where is pg_hba.conf

2017-08-13 Thread Igor Korot
Hi, armand, On Sun, Aug 13, 2017 at 10:12 AM, armand pirvu wrote: > Normally should reside in the data dir. My case below > > armandps-MacBook-Air:~ armandp$ ps -fu postgres |grep data > 502 29591 1 0 Thu09PM ?? 0:01.63 > /Library/PostgreSQL/9.6/bin/postgres -D /Library/PostgreSQL

Re: [GENERAL] Where is pg_hba.conf

2017-08-13 Thread Igor Korot
Hi, Christoph, On Sun, Aug 13, 2017 at 10:09 AM, Christoph Berg wrote: > Re: Igor Korot 2017-08-13 > >> I need to modify the pg_hba.conf file to get access to the DB >> remotely. >> >> However, I can't find this file anywhere on the system. > > Try "SHOW hba_file;". Last login: Sat Aug 12 23:4

Re: [GENERAL] Where is pg_hba.conf

2017-08-13 Thread armand pirvu
Normally should reside in the data dir. My case below armandps-MacBook-Air:~ armandp$ ps -fu postgres |grep data 502 29591 1 0 Thu09PM ?? 0:01.63 /Library/PostgreSQL/9.6/bin/postgres -D /Library/PostgreSQL/9.6/data armandps-MacBook-Air:~ armandp$ ls -l /Library/PostgreSQL/9.6/dat

Re: [GENERAL] Where is pg_hba.conf

2017-08-13 Thread Christoph Berg
Re: Igor Korot 2017-08-13 > I need to modify the pg_hba.conf file to get access to the DB > remotely. > > However, I can't find this file anywhere on the system. Try "SHOW hba_file;". Christoph -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your sub

[GENERAL] Where is pg_hba.conf

2017-08-13 Thread Igor Korot
Hi, I have a Mac with OSX 10.8 installed. It has Postgre 9.1. According to https://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html and http://www.thegeekstuff.com/2014/02/enable-remote-postgresql-connection/?utm_source=tuicool I need to modify the pg_hba.conf file to get access to the DB