Start :
sudo -i -u postgres openerp-server
# Must be : Client can only connect :
XML-RPC services, port 8069
NET-RPC service, port 80
######## In case some program is using the port :
sudo netstat -anpt
to discover what is running there, and record the PID
# You can check that the PID orresponds to a program you can dispense with by typing
ps aux | grep 1377
# and you can then stop the program from running by typing
sudo kill 1377
#########
# status :
ps auxww | grep ^postgres
/etc/init.d/postgresql status
#
service postgresql restart
netstat -tap | grep mysql
ss -4nlp
ps uaxww | grep -i openerp
sudo /etc/init.d/postgresql-8.4 restart
sudo gedit /etc/postgresql/8.4/main/pg_hba.conf
ps uaxww | grep -i openerp
sudo lsof -i :8069
sudo lsof -i :8070
sudo -i -u postgres openerp-server
sudo -u postgres psql
SELECT datname FROM pg_database;
sudo su - postgres -c psql
postgres@bani:~$ psql mydb
postgres@bani:~$ psql -l
postgres@bani:~$ createdb mydb
postgres@bani:~$ psql mydb
#################
# chaned uncommented lisstin = ´*´
sudo gedit /etc/postgresql/8.4/main/pg_hba.conf
#
sudo gedit /etc/postgresql/8.4/openbravo-erp/postgresql.conf
sudo gedit /etc/openerp-server.conf
###########
How to setup PostgreSQL SysV startup script?
$ su - root
# tar xvfz postgresql-8.3.7.tar.gz
# cd postgresql-8.3.7
# cp contrib/start-scripts/linux /etc/rc.d/init.d/postgresql
# chmod a+x /etc/rc.d/init.d/postgresql
