=?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
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:
>>
> 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
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 |
Hello,
My table details:
robox=# \dS+ updates
Table "public.updates"
Column | Type | Modifiers
| Storage | Stats target | Description
---+-+--
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
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.
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
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:
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
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
>
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
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
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
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
15 matches
Mail list logo