2018-11-28 10:40:01,906 9672 CRITICAL ? odoo.service.server: Failed to initialize database `abc`

Hello Community, Anyone has configured odoo with postgres? Please guide me with the below error. We have been experiencing an error while configuring the odoo(odoo 11.0) application to the postgres(postgres 10.5) database. We have done the configuration in two approaches. First Approach: All t

Re: Recovery data base!!

Hi Elson, Do you have the latest basebackup/filesystem backup of the instance? If yes you can recover to the backups taken time. Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: Password management in PostgreSQL

Hello Community, I wanted to know if password can be managed by the respective users at the time of their login, after their password has been expired? Consider the following case: *postgres=# create user pavan with login password 'password' valid until 'November 5 16:30:00 2018';* CREATE ROLE

Re: Async replication: how to get an alert on failure

Hi Karl, Hope my mail finds you in good time. >I wrote a small program that goes to each of the servers in the replication group and checks its status on the log, computes the difference, and if off by more than "X" bytes prints a notification. Did you configure ssh ?? >If this is run from th

Re: Granting a user the privilege to create views?

Hi Olivier, Instead if you grant select privilege on a table to a particular user, he can be able to create whatever the views he wants to. Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: Which background task looks for pg_xlog in 10?

Hi Johann, >>postgres postgres@template1 ERROR: could not open directory "pg_xlog": No such file or directory AFAIK, pg_xlog directory is changed to pg_wal in postgres 10. So pg_xlog directory can't be found. Did you connect to template1 database? Being a role model database for any newly cre

Re: Copying data from a CSV file into a table dynamically

Thank you so much Ron. You saved my efforts after a slight modification of quotes of the command you said, it started working fine. The modified command is as below: cat /tmp/xyz/abc/postgresql-`date --date="0 days ago" +%Y-%m-%d`_*.csv | psql -U aaa -d mydb -c "COPY postgres_log1 FROM STDIN WI

Re: Copying data from a CSV file into a table dynamically

Hi Adrian, I tried to use *"COPY postgres_log1 FROM '/tmp/abc/xyz/postgresql-`date --date="0 days ago" +%Y-%m-%d`_*.csv' WITH csv;"* But it resulted in an error. How to issue such that it is understandable by psql? And I am completely unaware of python & psycopg2. Anything which suits my requir

Re: Copying data from a CSV file into a table dynamically

Hi all, I am well versed with the COPY command for copying the contents of a csv file into a table. I am used to the below mentioned command: * COPY postgres_log1 FROM '/tmp/abc/xyz/postgresql-2018-08-14_00.csv' WITH csv;* But in the location "/tmp/abc/xyz/" daily a file(with header postgres

Re: First query on each connection is too slow

Hi Andres, Please find the below link: Link: http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server#shared_buffers Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f18437

Re: [External] Merging two database dumps

Yes Vijay, It might work, but I'm thinking it will be a performance overhead in case of complex data. Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: How to get postmaster shut down time in postgres?

Hi Tom Lane, I'm glad that I got a reply from you. And yes you are exactly correct. I am looking for the time that shutdown begins. I fulfilled my requirement by adding a piece of code before the initiation of shutdown in the postgresql service file located in /etc/init.d folder of my ubuntu ser

Re: How to get postmaster shut down time in postgres?

Hi Tom Lane, I'm glad that I got a reply from you. And yes you are exactly correct. I am looking for the time that shutdown begins. I fulfilled my requirement by adding a piece of code before the initiation of shutdown in the postgresql service file located in /etc/init.d folder of my ubuntu ser

Re: How to get postmaster shut down time in postgres?

Hi Tom Lane, I'm glad that I got a reply from you. And yes you are exactly correct. I am looking for the time that shutdown begins. I fulfilled my requirement by adding a piece of code before the initiation of shutdown in the postgresql service file located in /etc/init.d folder of my ubuntu ser

Re: How to get postmaster shut down time in postgres?

Hi Adrian/Melvin, Thanks for your prompt replies. Yeah, I'm aware of that way. But my requirement is to get the server shutdown time whenever that event occurs and insert into a table dynamically!! Is it possible? The main reason for my requirement is to find the time swing between server stop

How to get postmaster shut down time in postgres?

Hi all, Is there any way to get postmaster(postgres database) shutdown time? Please help!! Thanks in Advance. Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: Fwd: Tracking DDL and DML changes in Postgresql and different versions of database (advance)

Hi Luke, >Thank you Pavan, >I have a few questions. >Could you please describe in more details about event triggers? Maybe some examples how to start with this? Please refer the below link for more detailed information about "Event Triggers". Link: https://www.postgresql.org/docs/10/static

Re: Upgrading from Postgresql 9.1 to 10

Thankyou Michael -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Upgrading from Postgresql 9.1 to 10

Hi all, Is it possible to upgrade an existing postgresql 9.1 production system to latest Postgres 10.0 version? The main requirement is to get rid of downtime. Please help me out! Thanks in Advance. Regards, Pavan -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.ht