On Sun, Dec 18, 2005 at 09:56:39PM -0500, Chris Browne wrote:
> The filenames are the OID numbers associated with either databases
> (see pg_catalog.pg_database) or tables (see pg_catalog.pg_class).
For tables, indexes, etc., the filename isn't necessarily the same
as the object's oid; it starts o
[EMAIL PROTECTED] (Ken Hill) writes:
> That works nice. It shows my data directory in
> '/var/lib/postgresql/7.4/main'. When I do an ls command, I get:
>
> $ sudo ls /var/lib/postgresql/7.4/main
> basepg_clog pg_ident.conf pg_xlog postmaster.opts
> root.crt
> global pg_hba.conf
There they are:
csalgorithm=# SELECT oid,datname FROM pg_database;
oid | datname
---+-
17142 | testdb
17143 | csalgorithm
1 | template1
17141 | template0
(4 rows)
Thank you for the help!
On Mon, 2005-12-19 at 03:01 +0200, Devrim GUNDUZ wrote:
> Hi,
>
> On Sun, 18 De
Ken Hill wrote:
> I have created two database named 'testdb' and 'csalgorithm'. How do I
> find these databases?
Unless you are an expert user, you probably shouldn't be trying to find
them at all. All database administration is done through the frontend.
--
Peter Eisentraut
http://developer.p
On Sun, Dec 18, 2005 at 04:34:16PM -0800, Ken Hill wrote:
> That works nice. It shows my data directory in
> '/var/lib/postgresql/7.4/main'. When I do an ls command, I get:
>
> $ sudo ls /var/lib/postgresql/7.4/main
> basepg_clog pg_ident.conf pg_xlog postmaster.opts
> root.crt
Hi,
On Sun, 18 Dec 2005, Ken Hill wrote:
I have created two database named 'testdb' and 'csalgorithm'. How do I
find these databases? I was expecting the databases to be subdirectories
under the database directory (e.g. /var/lib/postresql/7.4/main/testdb
and /var/lib/postgresql/7.4/main/csalgo
That works nice. It shows my data directory in
'/var/lib/postgresql/7.4/main'. When I do an ls command, I get:
$ sudo ls /var/lib/postgresql/7.4/main
basepg_clog pg_ident.conf pg_xlog postmaster.opts
root.crt
global pg_hba.conf PG_VERSION postgresql.conf postmaster.pid
I
Then an easy way is likely to look at the init script that starts it, or use
ps auxwww |grep postmaster to have a look at how it was started. The last
command will likely yield something that looks like this:
postgres 3026 0.0 0.3 20064 3176 ?S08:21 0:00
/usr/bin/postmaster
I'm using 7.4.8 so that does not work. Any other suggestions?
On Fri, 2005-12-16 at 15:50 -0800, Jeff Frost wrote:
> Run the following query:
>
> show data_directory;
>
>
> On Fri, 16 Dec 2005, Ken Hill wrote:
>
> > database, but I can find the directory where the database are kept. How
> > do
Run the following query:
show data_directory;
On Fri, 16 Dec 2005, Ken Hill wrote:
database, but I can find the directory where the database are kept. How
do I find where the postgresql database directory is from a command
line?
--
Jeff Frost, Owner <[EMAIL PROTECTED]>
Frost Consultin
Ken Hill <[EMAIL PROTECTED]> writes:
> How do I find where the postgresql database directory is from a command
> line?
Since 8.0 you can do "show data_directory".
regards, tom lane
---(end of broadcast)---
TIP 9: In versions
I installed postgresql using the Synaptic Package Manager on my Ubuntu
distro. I created the 'postgres' user account. I can create users and
database, but I can find the directory where the database are kept. How
do I find where the postgresql database directory is from a command
line?
--
12 matches
Mail list logo
