Re: Location of databases - Mailing list pgsql-novice

From Andreas Wenk
Subject Re: Location of databases
Date
Msg-id 4A6ECB5A.5080305@netzmeister-st-pauli.de
Whole thread Raw
In response to Re: Location of databases  (Michael Wood <esiotrot@gmail.com>)
Responses Re: Location of databases  (Peter Jackson <mltasmaniac@tasjackson.com>)
Re: Location of databases  (Peter Jackson <tasmaniac@iprimus.com.au>)
List pgsql-novice
Michael Wood schrieb:
> 2009/7/28 Andreas Wenk <a.wenk@netzmeister-st-pauli.de>:
>> john shipley schrieb:
> [...]
>>> In order to load the contents of a PostgreSQL file into PSPP,
>>> I have to show its location and name and indicate that is is a PostgreSQL
>>> file by means of a statement like the following:
>>>
>>> FILE = /home/myusername/.../.../.../ filenamedb(PSQL).
>
> I don't know anything about PSPP, but you cannot directly access the
> files used by PostgreSQL.  You have to use a client like psql or
> ODBC/JDBC or the PostgreSQL client libraries to talk to PostgreSQL and
> PostgreSQL reads/writes the files itself.  This is why the location of
> the files is generally not something you need to know.  What you do
> need to know is things like the IP address of the machine running
> PostgreSQL and the port number that PostgreSQL is running on (unless
> you're on the same machine and you're using a Unix domain socket to
> talk to PostgreSQL.)

hm - I think you are right. So maybe this PSPP is not working with a database like PG at
all. Or something else has to be set up.

My focus was more to show where the files and direcotries are located generally. Maybe
this was not helping to find a solution ...

Cheers

Andy

pgsql-novice by date:

Previous
From: Andreas Wenk
Date:
Subject: Re: Understanding the output of EXPLAIN ANALYSE
Next
From: Petros Thespis
Date:
Subject: Select from second table only if select from first returns no results