Thursday, November 5, 2015

odoo db postgres ops, import restore; Odoo development Essentials create odoo serevice; api;


 git clone --depth 1 --branch 8.0 https://github.com/odoo/odoo.git odoo8

https://www.odoo.com/forum/help-1/question/website-guest-customer-portal-user-63938
It appears that your package manager failed to create the database named $user for you. The reason that
psql -d template1
works for you is that template1 is a database created by postgres itself, and is present on all installations. You are apparently able to log in to template1, so you must have some rights assigned to you by the database. Try this at a shell prompt:
createdb
and then see if you can log in again with 
psql -h localhost
This will simply create a database for your login user, which I think is what you are looking for. If createdb fails, then you don't have enough rights to make your own database, and you will have to figure out how to fix the homebrew package.
http://stackoverflow.com/questions/17633422/psql-fatal-database-user-does-not-exist
 \l
on mac,shows a list of the databases,


pg_restore -d odoo8 /Users/jing/Documents/repo/dump/dump.sql
pg_restore: [archiver] input file appears to be a text format dump. Please use psql.

http://stackoverflow.com/questions/21122598/postgres-user-does-not-exist
psql odoo8 < /Users/jing/Documents/repo/dump/dump.sql
role "postgres" does not exist
seems it doesn’t matter all tables database created
the race condition with LESS and viewing the website as a logged in editor while also viewing it as a logged out visitor

API

import xmlrpclib
srv,db = ‘http://localhost:8069', ‘v8dev
user,pwd = ‘admin’,’jing
common = xmlrpclib.serverProxy(‘%s/xmlrpc/2/common’ % src)
common.version()

api=xmlrpclib.ServerProxy(‘%s/xmlrpc/2/object’ %srv)
api.execute_kw(db, uid, pwd, ‘res.partner’, ‘search_count’, [[]])


local clone
from stage to the prod site
git clone ~/odoo-dev/odoo ~/odoo-prd/odoo

set up as system service
sudo cp ~/odoo-prd/odoo/debian/init /etc/init.d/odoo
sudo chmod +x /etc/init.d/odoo

open the init, script
sudo ln -s ~/odoo-prd/odoo/odoo.py /usr/bin/openerp-server
sudo chown $(whoami) /usr/bin/openerp-server
create the log file directory
sudo mkdir /var/log/odoo
sudo chown $(whoami) /usr/bin/openerp-server

be able to start /stop odoo service
sudo /etc/init.d/odoo start
being able to get back 
when curl http://localhost:8069
ubuntu
easier command to remember:
sudo service odoo start
start auto on system boot
sudo update-rc.d odoo defaults