Re: upgrade postgres 9.5 to 9.6

-3 hours) so > please help me how should I perform it. > > > Please share the document, if possible, it will be grateful. > > > > Regards, > Atul -- Enrico Pirozzi

Re: PostegreSQL 9.2 to 9.6

Hi Lucas I've made it, from 9.2 to 12.2 using slony and it worked very well :) Enrico Il sab 28 mar 2020, 13:29 Lucas Possamai ha scritto: > Hi guys. > > We need to upgrade (asap) our PostgreSQL 9.2 cluster. We run our cluster > on AWS EC2 instances, and want to upgrade to RDS 9.6. Once in RDS

Re: Foreign keys and locks.

Solved, it was an index that didn't work well :) Enrico Il giorno mer 20 nov 2019 alle ore 15:16 Enrico Pirozzi ha scritto: > Hi all, > Today I found this behavior on two tables. > > I have 2 tables t2 and t3 , described as below: > > testdb=# \d t2 >

Foreign keys and locks.

Hi all, Today I found this behavior on two tables. I have 2 tables t2 and t3 , described as below: testdb=# \d t2 Tabella "public.t2" Colonna | Tipo | Ordinamento | Può essere null | Default -+-+-+-+- id | integer

Re: migrating from Oracle to PostgreSQL 11

Chadda ha scritto: Hi PostgresSQL Support, I have to migrate from Oracle 11g to PostgresSQL 11.4. Please suggest best solution for doing the migration. Regards H.Kumar -- Questo messaggio è stato analizzato con Libra ESVA ed è risultato non infetto. -- Enrico Pirozzi NBS Group S.r.l. via Val

Re: postgresql api

Hi, Have you tried to query the pg_stat_replication? Enrico Il lun 17 set 2018, 11:52 vyshu Ysh ha scritto: > Hi Team, > > Is there any postgresql API which tells when the master/standby server is > down ? > > Thanks, > Sudha >

Re: Problem Postgres

e Musella -- Questo messaggio è stato analizzato con Libra ESVA ed è risultato non infetto. -- Enrico Pirozzi NBS Group S.r.l. via Val Tiberina 23/A 63074, San Benedetto del Tronto (AP) Tel. 0735-7626201

Re: New website

roll out a demo site for testing first. Will reserve judgment on the site design until it is functioning. -- Enrico Pirozzi NBS Group S.r.l. via Val Tiberina 23/A 63074, San Benedetto del Tronto (AP) Tel. 0735-7626201

Re: Fixed chars

regular expressions." Il 28/03/2018 11:32, Andreas Kretschmer ha scritto: Am 28.03.2018 um 11:11 schrieb Enrico Pirozzi: Hi , I've seen this strange thing. sitedb=# create table test_tb(codice char(7)); CREATE TABLE sitedb=# insert into test_tb values('pippo'); INSER

Fixed chars

| 5 (1 row) On the official documentation |character(/|n|/)|,|char(/|n|/)| fixed-length, blank padded https://www.postgresql.org/docs/10/static/datatype-character.html Can anyone help me? Enrico -- Enrico Pirozzi NBS Group S.r.l. via Val Tiberina 23/A 63074, San Benedetto del Tronto (AP) Tel. 0735-7626201

Re: PostgreSQL 9.6: view based on sequence

whatever types the system table uses. There is nothing from with that. -- Enrico Pirozzi e.piro...@nbsgroup.it

Re: PostgreSQL 9.6: view based on sequence

It is all documented here: https://www.postgresql.org/docs/10/static/release-10.html#idm46428658049888 "...selecting from a sequence relation now returns only the three fields named above." And there's no way to keep portability from 9.x to 10.x Thanks ;) Enrico -- Enrico

Re: PostgreSQL 9.6: view based on sequence

Yes the query is legal,but if you use pg_upgrade to upgrade from 9.6 to 10.x , pg_upgrade will fail . Enrico Il 24/01/2018 13:11, Vincenzo Romano ha scritto: Those queries are all legal. No warning is due. -- Enrico Pirozzi e.piro...@nbsgroup.it

Re: PostgreSQL 9.6: view based on sequence

ine. If it's to access the sequence metainfo, then maybe it'd be better to explore the pg_catalog schema. -- Enrico Pirozzi e.piro...@nbsgroup.it

Re: PostgreSQL 9.6: view based on sequence

iao. Yes but this happens on a 10.x version on a 9.6 version things are differents Ciao Enrico -- Enrico Pirozzi e.piro...@nbsgroup.it

Re: PostgreSQL 9.6: view based on sequence

iao. Yes but this appens on a 10.x version :) Ciao -- Enrico Pirozzi e.piro...@nbsgroup.it

PostgreSQL 9.6: view based on sequence

n the view, there is a field named sequence_name with datatype name. I've seen in the docs https://www.postgresql.org/docs/9.6/static/datatype-character.html and the datatype name should be reserved only for structures internal of PG. Does anyone help me? Enrico -- Enrico Piro

Re: Connection type

Il 18/01/2018 17:19, Steve Atkins ha scritto: A client can voluntarily set the application_name, e.g. as part of it's connection string, to identify itself to the server, if you want to be able to identify which sort of client is connected easily. Thank you very much :) Regards Enrico

Connection type

Hi, is there a way to know what kind of connection a client is doing? (ODBC,JDBC..etc) I saw the pg_stat_activity view, but in the application name field there no infomation about what kind of connection a client is doing. Thanks Enrico e.piro...@nbsgroup.it