I am new to postgresql. I am having some weird problems. Output attached below. Please any help would be appreciated.
bash-3.2$ createdb test1 could not change directory to "/root" bash-3.2$ dropdb test could not change directory to "/root" bash-3.2$
any recommendations. Some additional info. This is on a cenos 5.4 with full admin rights.
bash-3.2$ ps ax | grep post 11329 pts/2 S 0:00 su postgres 11578 pts/2 R+ 0:00 grep post 17894 ? S 0:02 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data 17899 ? Ss 0:00 postgres: logger process 17901 ? Ss 0:00 postgres: writer process 17902 ? Ss 0:00 postgres: wal writer process 17903 ? Ss 0:00 postgres: autovacuum launcher process 17904 ? Ss 0:18 postgres: stats collector process bash-3.2$