Re: Question on pgwatch

2019-08-23 Thread Georg H.
Hi Bikram, Am 23.08.2019 um 22:10 schrieb Bikram Majumdar: Hi George, So nice for your response. Thanks. But, my question is how does it get the IP address 172.17.0.2 ? And, how does one run psql command to connect/login to the test database ( pgwatch configuration database)  to add any

Re: Question on pgwatch

2019-08-23 Thread Georg H.
Hello Bikram, Am 22.08.2019 um 23:50 schrieb Bikram MAJUMDAR: Hi, Need help from anyone in the team who has worked on pgwatch2. Yesterday we installed pgwatch2 docker image and started the container. We are running the pgwatch2 container from the database server itself - Now we want to add

Re: logging "raise" to file

2019-07-28 Thread Georg H.
Hi, Am 28.07.2019 um 12:32 schrieb wambac...@posteo.de: Hi, is there a way to log output from "raise ..." to a local file? \o file does not work (for me). regards walter the red part writes your "raise notice" to your log psql (+your connection string) -f /path/to/file.sql *>

Re: short sql question

2021-06-18 Thread Georg H.
Hi, Am 18.06.2021 um 09:15 schrieb goldgraeber-werbetech...@t-online.de: Hi, I just cannot see what is wrong with my query: create table files (id int, name text, prev_name text, ); create table fnchanged (id int, name text); update files f set prev_name = f.name, name = c.name from

Re: PostgreSQL reference coffee mug

2021-07-28 Thread Georg H.
Hello Matthias, Am 28.07.2021 um 15:40 schrieb Matthias Apitz: El día martes, julio 27, 2021 a las 08:32:45p. m. +0200, Matthias Apitz escribió: Thank you, Pavel. This is ofc to much for a coffee mug. For using it as a Reference Card in paper form, it's a pity that it is not written in

Re: Converting sql anywhere to postgres

2023-08-15 Thread Georg H.
Hi, Am 15.08.2023 um 17:04 schrieb Russell Rose | Passfield Data Systems: Hi there I am trying to convert a SQL Anywhere database to postgres. Within SQL anywhere a field can have a default value of ‘last user’. This means that when you perform an update on a table, if the field is not

Re: psql "\d" no longer working

2023-02-12 Thread Georg H.
Hello Rob, Am 12.02.2023 um 10:02 schrieb Rob Sargent: Seems I've lost the table definition meta-command riftehr=> \d actual_and_inf_rel_clean_final ERROR:  column c.relhasoids does not exist LINE 1: ..., c.relhasindex, c.relhasrules, c.relhastriggers, c.relhasoi... while

Re: best migration solution

2024-04-25 Thread Georg H.
Hello Markus, keep it simple. Use a restored backup of the source db or this db itself and then Am 25.04.2024 um 09:55 schrieb Zwettler Markus (OIZ): we have to migrate from hosted PG12 to containerized PG16 on private cloud. some of the installed PG12 extensions are not offered on the