I have upgraded my postgres database to 9.2 to 10.9.
After upgrade getting below error :
Java.lang.illegalstateexception: 3 rows retrieved for single property
server is.Checksum.
Can some one please help on this issue?
On Mon, Jul 29, 2019 at 2:22 PM Sonam Sharma wrote:
> Java.lang.illegalstateexception: 3 rows retrieved for single property server
> is.Checksum.
This has nothing to do with PostgreSQL, at least I suspect you have
got a query that is not strict and is returning more than a row.
You need to provi
I work with Protected Health Information so have restricted access to an
important database.
I would like to look into index and query changes for that database. It occurs
to me that if I was able to reproduce the statistics and cost settings for the
database, then Explain would produce identic
On 7/29/19 12:07 PM, Guyren Howe wrote:
I work with Protected Health Information so have restricted access to an
important database.
I would like to look into index and query changes for that database. It
occurs to me that if I was able to reproduce the statistics and cost
settings for the da
On Jul 29, 2019, at 12:25 , Adrian Klaver wrote:
>
> On 7/29/19 12:07 PM, Guyren Howe wrote:
>> I work with Protected Health Information so have restricted access to an
>> important database.
>> I would like to look into index and query changes for that database. It
>> occurs to me that if I wa
Guyren Howe writes:
> On Jul 29, 2019, at 12:25 , Adrian Klaver wrote:
>> If you can't see/use the data in the production database in your test
>> database I'm not sure how copying the statistics/cost settings is going to
>> help.
> Isn’t that the entirety of what the query plan is based on?
On 7/29/19 3:08 PM, Tom Lane wrote:
Guyren Howe writes:
On Jul 29, 2019, at 12:25 , Adrian Klaver wrote:
If you can't see/use the data in the production database in your test database
I'm not sure how copying the statistics/cost settings is going to help.
Isn’t that the entirety of what t
Hi all.
I need to create a PostgreSQL account , that only do a Backup and Restore
operations over a PGSQL Database .
My main difficulty is to only assign Backup and Restore capability to one
user account, unlike the ability to perform DQL and DML operations for
ordinary user accounts.
In POSTGRE
> On Jul 29, 2019, at 7:49 PM, Marcos Aurelio Nobre
> wrote:
>
> Hi all.
>
> I need to create a PostgreSQL account , that only do a Backup and Restore
> operations over a PGSQL Database .
>
> My main difficulty is to only assign Backup and Restore capability to one
> user account, unlike t
On Tue, Jul 30, 2019 at 2:50 AM Marcos Aurelio Nobre
wrote:
> I was wondering if it was possible to configure the pgAdmin4 menus to be
> available for a particular login, only Backup & Restore items. But I'm not
> sure how to associate a bank login account with a specific menu setting of a
> cl
10 matches
Mail list logo
