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:
>
>
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 A1t/ A
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 A2
Valid point.
I've added that to the report.
Best regards,
Martin Skjoldebrand
Disclaimer: This message and the information contained herein is proprietary
and confide
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 c
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 org
> 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 why
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 countries,
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 b
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
Disclaime
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 o
: 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
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 go
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. We'r
Thanks for your input.
/M.
Disclaimer: This message and the information contained herein is proprietary
and confidential and subject to the Tech Mahindra policy statement
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 h
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 existi
17 matches
Mail list logo