PostgreSQL "initdb" (Database Initialization) on Linux -


i'm working on creating database cluster (single database) in postgresql 9.x working on linux system (centos - redhat - fedora). i've installed correct postgresql packages (server & client) however, i'm unable create database , type of initializing dependencies error: bus error / exit code 135. i've changed user "postgres" "su postgres" , tried initialize database "initdb" (this may problem)

installed: postgresql-libs-9.2.13-1.el7_1.x86_64 installed: postgresql-9.2.13-1.el7_1.x86_64 installed: postgresql-server-9.2.13-1.el7_1.x86_64  $ initdb -d /usr/local/pgsql/data 

http://www.postgresql.org/docs/9.2/interactive/creating-cluster.html

error:

$ initdb -d /usr/local/pgsql/data files belonging database system owned user "postgres". user must own server process.  database cluster initialized locale "en_us.utf8". default database encoding has accordingly been set "utf8". default text search configuration set "english".  creating directory /usr/local/pgsql/data ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 32mb creating configuration files ... ok creating template1 database in /usr/local/pgsql/data/base/1 ... ok initializing pg_authid ... ok initializing dependencies ... sh: line 1: 12616 bus error               (core dumped) "/usr/bin/postgres" --single -f -o -c search_path=pg_catalog -c exit_on_error=true template1 > /dev/null child process exited exit code 135 

any ideas?

after installing postgresql (server , client tools) 1 needs run following commands root ("su"). key step start "service postgresql initdb" , let initialize postgresql database.

if have errors need remove empty install "data" directories , read log files carefully.

# service postgresql initdb # systemctl enable postgresql # systemctl start postgresql 

after doing above verify postgres in /var/lib/pgsql , running process "ps -ef | grep postgres" (its on port 5432)

if run other problems may need create or modify postgres user/password or clean postgres data directory out.


Comments

Popular posts from this blog

dns - How To Use Custom Nameserver On Free Cloudflare? -

python - Pygame screen.blit not working -

c# - Web API response xml language -