SV: Databases and servers

Från: Peter J. Holzer Skickat: den 20 augusti 2019 22:58 Till: pgsql-general@lists.postgresql.org Ämne: Re: Databases and servers On 2019-08-20 10:33:17 +, Karl Martin Skoldebrand wrote: > I just discovered that a client has done this: > >

SV: Databases and servers

On Tue, Aug 20, 2019 at 6:33 AM Karl Martin Skoldebrand mailto:ks0c77...@techmahindra.com>> wrote: Hi, I just discovered that a client has done this: They have two web applications A1 and A2. They have seperate hostnames/URLs. Both have a production and a test database A1p and A1

Databases and servers

Hi, I just discovered that a client has done this: They have two web applications A1 and A2. They have seperate hostnames/URLs. Both have a production and a test database A1p and A1t/ A2p and A2t. What they've done is have both A1p and A2p on the same actual databaser server and A1t and

RE: Too short field

Valid point. I've added that to the report. Best regards, Martin Skjoldebrand Disclaimer: This message and the information contained herein is proprietary and

RE: Too short field

Thanks. That is what I thought - good to have a confirmation. Best regards, Martin S Disclaimer: This message and the information contained herein is proprietary and

Too short field

Hi, We solved the problem of yesterday where I was looking at sequences. It eventually turned that sequence was irrelevant (at least in the PostgreSQL sense) to the problem. Now, we have a bug in another application that prevents an automatic tool to enter certain users in the database. The

RE: Sequences part 2

> Yes, I'm fairly aware of this. However the application the database table > belongs to seems to rely on a specific order in the database. I.e. if I just > add value to the table they end up, possibly due to how the application is > coded in an undesireable spot on the web page. > That is

RE: Sequences part 2

Karl Martin Skoldebrand schrieb am 02.07.2019 um 12:44: > Looking more at sequences, I have some sequences that start with ID 1, > incrementing each record by 1. > > So I have e.g. 1 Spain 2. Germany 3. France 4. Ireland 5. Norway > > Now I want to insert more countri

Sequences part 2

Hi again, Looking more at sequences, I have some sequences that start with ID 1, incrementing each record by 1. So I have e.g. 1 Spain 2. Germany 3. France 4. Ireland 5. Norway Now I want to insert more countries, between France and Ireland. And also alter the increment. That latter part might

RE: sequences

Thanks for replies. I looked at some tutorial page and there were more instructions in that, so got confused. I was aware sequences create integers. //Martin S

sequences

Hi, I'm trying to troubleshoot a case where users are getting data from a database, despite they having said they are not interested. There is a number of sequences in the database in question, but to me they look "empty", like stubs. create sequence db_table_seq; alter sequence db_table_seq

RE: Transactions

: 09 April 2019 11:41 To: pgsql-general@lists.postgresql.org Subject: Sv: Transactions På tirsdag 09. april 2019 kl. 11:26:29, skrev Karl Martin Skoldebrand mailto:ks0c77...@techmahindra.com>>: Hi, Is there a way to track “transactions” by default (i.e. without anyone having set up an

Transactions

Hi, Is there a way to track "transactions" by default (i.e. without anyone having set up anything specific). The problem I am facing is that users are claiming that settings are disappearing with them doing anything to affect them. It would be good to be able to see what postgresql thinks is

RE: Recommendation for upgrading from PostgreSQL 9.3

Thanks, >https://www.postgresql.org/docs/10/release.html That's a massive list. But going for the first major release makes it manageable. > --- >To be more certain I would set up a dev database with the new version and test >against >that. Aye, we've got a production and a test server.

RE: Recommendation for upgrading from PostgreSQL 9.3

Thanks for your input. /M. Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy

RE: Recommendation for upgrading from PostgreSQL 9.3

I found a note on logical replication in PostgreSQL 10.x with the caveat "There are also a number of caveats regarding what objects are actually replicated-for example, only tables are replicated, such objects as views and sequences are not." Does replication in 10.x now include views etc? We

Recommendation for upgrading from PostgreSQL 9.3

Are there any recommendations regarding upgrading from PG 9.3 to 9.6 or 10.x? I found a few changes at https://severalnines.com/blog/upgrading-your-database-to-postgresql-version-10 but are there more things to keep in mind regarding changes in scripts/queries that might affect an already