postgresql: restore db from sql
#Upload the backup .sql file to the server #Execute the following command. root@ubuntu:~# psql -Uadempiere idempiere < /opt/idempiere-server/DBImport/DB3.sql
Category: postgresql
postgresql: update column from another table’s column
UPDATE c_order SET po_refernce_no = (SELECT po_refernce_no FROM “Import” WHERE c_order_id = c_order.c_order_id), tracking_number = (SELECT tracking_number FROM “Import” WHERE c_order_id = c_order.c_order_id) UPDATE m_product SET manufacturer = (SELECT m_product_po.manufacturer FROM m_product_po WHERE m_product.m_product_id = m_product_po.m_product_id )
postgresql: remove single quotes after table import.
After several iterations this one worked for me: UPDATE “Import” SET tracking_number = NULL where tracking_number =”;
pgsql: pgdump authentication
create .pg_pass file on the root folder of the user that will run the pgsql command for example. /root or /user touch /root/.pgpass chmod 600 .pgpass add the credentialas user and password that will be user […]
pgsql: list and remove triggers
I want to delete directly on the PgSQL database on my OpenBravo application but it has a los of triggers that prevent certain actions, first I want to list them and after that will want to disable them. List: SELECT […]
pgsql: cannot delete line on table.
This happens when I try to manually delete a record on the Database ERROR: update or delete on table “m_inoutline” violates foreign key constraint “m_inoutline_canceled_inoutline” on table “m_inoutline” DETAIL: Key (m_inoutline_id)=(8310BD9D63A94DB5A2294EC8E48C6C9F) is still referenced from table “m_inoutline”. ********** Error […]
pgsql: cannot use extract function inside a where clause
For Exmple: AND (date_part(‘YEAR’,fin_finacc_transaction.statementdate) = $P{Año}) or AND ((extract(Year from fin_finacc_transaction.statementdate) LIKE $P{Año}) OR $P{Año} = ‘ALL’) Neither of these work, I guess it has something to do with the Parameter type, as it works when I use a […]
postgresql: relevant commands
Connecting to Postgress Shell psql -U postgres -d postgres List Users select * from pg_shadow; usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig Change User Password ALTER USER colin WITH PASSWORD ‘letmein’; […]
postgresql: not listening
http://stackoverflow.com/questions/12286886/postgresql-server-doesnt-listen ERROR 1 could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host “xxx.xxx.xxx.xxx” and accepting TCP/IP connections on port 5432? listen_addresses = ‘*’ in /etc/postgresql/9.1/main/postgresql.conf. ERROR 2 FATAL: no pg_hba.conf entry for host “xxx.xx.xxx.xxx”, user […]