#You can easily hide or remove fields from odoo filter by inheriting function fields_get()
@api.model
def fields_get(self, fields=None):
show = ['file_name','partner_id','line_partner_ids','common_message','state','upload_type']
group = ['partner_id','state','upload_type']
res = super(SendDocument, self).fields_get()
for field in res:
res[field]['selectable'] = False
res[field]['sortable'] = False
for field in show:
res[field]['selectable'] = True
for field in group:
res[field]['sortable'] = True
return res
Category: Postgresql
How to drop database(PostgreSQL) if there are active connections to it(PostgreSQL database is being accessed by other users)?
- PostgreSQL 9.2 and above:
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'database_name' -- ← change this to your DB
AND pid <> pg_backend_pid();
OR
- PostgreSQL 9.1 and below:
SELECT pg_terminate_backend(pg_stat_activity.procpid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'database_name' -- ← change this to your DB
AND procpid <> pg_backend_pid();
sudo su postgres
psql
drop database database_name;
Backup/Export Odoo postgres database
mkdir “/opt/odoo/backup/”
chown -R postgres:postgres /opt/odoo/backup
sudo su postgres
pg_dump -E UTF-8 -p 5432 -F p -b -f /opt/odoo/backup/backupfile.sql databasename
Run Odoo from terminal using addons path
sudo su – odoo -s /bin/bash
$ cd /opt/odoo/
$ ./odoo-bin –addons-path=/odoo/odoo-server/addons/,/odoo/odoo-server/odoo/addons/,/odoo/custom/addons
Reset Odoo admin password to ‘admin’.
Login to the Postgres.Select Odoo database.
Run the below query
UPDATE res_users
SET password='$pbkdf2-sha512$6400$1HovZUzJOQdgTElJCYFwrg$3duyQnYOKKVKZ34iK54tKy.OxrfJM2SnJnDlGgqAmrF.suA73gaESJkCoPcIC6vB2.NwBYAUGvD9/6ZjEexn/w' WHERE login='admin';
Login PostgreSQL using SSH
To connect using the psql client , use the following command.
psql -h server_ip -U psql_user_name database_name
Peer authentication failed for user – postgresql pgadmin
- Edit the below line in pg_hba.conf.
sudo vim /etc/postgresql/9.3/main/pg_hba.conf
host all all 127.0.0.1/32 md5 to host all all all md5
# "local" is for Unix domain socket connections only local all postgres trust
2. Edit the below line in postgresql.conf.
sudo vim/etc/postgresql/9.3/main/postgresql.conf
# - Connection Settings - listen_addresses = '*'
Import database dump/sql in to Postgresql
$ sudo su postgres
$ psql
$ create database db_name;
$ psql db_name < db_name.sql
Export database dump/sql from Postgresql
$sudo pg_dump databse_name > /opt/databse_name .sql $sudo pg_dump databse_name > /opt/databse_name .dump