postgresql work without config files

ReneVielma · 2008-05-29 23:30:55

Hello

After last upgrade of postgresql, I'm not config files of postgresql
(to this, I backup all databases, upgrade postresql to 8.3.1-1 and restore all databases without problem)

but

$  pacman -Ql postgresql postgresql-libs|grep etc
postgresql /etc/
postgresql /etc/conf.d/
postgresql /etc/conf.d/postgresql
postgresql /etc/rc.d/
postgresql /etc/rc.d/postgresql
postgresql /usr/share/man/man7/fetch.7.gz
$  locate postgres|grep etc
/etc/conf.d/postgresql
/etc/rc.d/postgresql
$

but the service work fine

where is config files
any idea ?

thanks you

peart · 2008-05-30 02:06:02

I haven't used postgres in a while, but I remember some of the files were in /var/lib/postgres. Could that be the directory you are looking for?

fukawi2 · 2008-06-02 04:25:51

Config files reside in the PostgreSQL data directory, so it depends where you have set that to be using initdb.

Defaults are usually /usr/local/postgresql/data or /var/lib/postgresql/data

dextrose · 2008-09-06 20:23:40

I'm posting in this thread because I'm looking at it like a wiki. Perhaps we can make a wiki out of this also..

After installing the package with pacman, by initializing postgresql daemon for the first time, I am asked for a password I haven't been asked for.
I usually always use the same set of password, though after trying the standart ones, none of them really worked so I have no idea which password the service is asking for.

also, "postgres cannot access the server configuration file "/var/lib/postgres/data/postgresql.conf": Permission denied"

although before, I have quote:

 /etc/rc.d/postgresql restart
:: Stopping PostgreSQL                                                                                                                                [BUSY] su: user postgres does not exist
                                                                                                                                                      [FAIL] 
:: Starting PostgreSQL                                                                                                                                [BUSY] :: Adding postgres group                                                                                                                              [DONE] 
:: Adding postgres user                                                                                                                               [DONE] 
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.
The default database encoding has accordingly been set to SQL_ASCII.
The default text search configuration will be set to "english".

fixing permissions on existing directory /var/lib/postgres/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers/max_fsm_pages ... 24MB/153600
creating configuration files ... ok
creating template1 database in /var/lib/postgres/data/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok

Success. You can now start the database server using:

    /usr/bin/postgres -D /var/lib/postgres/data
or
    /usr/bin/pg_ctl -D /var/lib/postgres/data -l logfile start

server starting [DONE]

although, postgree post-installation claims to fix the permissions on the directory, by starting the database server:

]$ postgres -D /var/lib/postgres/data/
postgres cannot access the server configuration file "/var/lib/postgres/data/postgresql.conf": Permission denied
[jorge@arch64 postgresql]$ cd /var/lib/postgres/data/   
bash: cd: /var/lib/postgres/data/: Permission denied
[jorge@arch64 postgresql]$ /usr/bin/pg_ctl -D /var/lib/postgres/data -l logfile start
pg_ctl: could not open PID file "/var/lib/postgres/data/postmaster.pid": Permission denied

I went to have a look at the directory and :
]$ cd /var/lib/postgres/
[jorge@arch64 postgres]$ ls -l
total 0
drwx------ 10 postgres postgres 464 Sep 6 15:24 data
[jorge@arch64 postgres]$

What is going wrong with this? Any Ideas?

Kind Regards,
Jorge Nunes.

Forty · 2008-10-01 14:10:09

I'm having the exact same problem as the poster above me.

kett · 2008-10-01 14:34:00

My guess would be postgres is already started. I just installed it, and got it to work fine, by just running /etc/rc.d/postgres start after the. Try running the following command:

 psql template1 -U postgres

If that works, it means your postgres server is already running. psql is the client application to access a specific database.

Last edited by kett (2008-10-01 14:35:08)

Arch Linux

#1 2008-05-29 23:30:55

postgresql work without config files

#2 2008-05-30 02:06:02

Re: postgresql work without config files

#3 2008-06-02 04:25:51

Re: postgresql work without config files

#4 2008-09-06 20:23:40

Re: postgresql work without config files

#5 2008-10-01 14:10:09

Re: postgresql work without config files

#6 2008-10-01 14:34:00

Re: postgresql work without config files

Board footer