Hi Tom,
Thank you for your help.
As we use ansible to deploy the upgrade, so mentioned the data centers
situation. The PostgreSQL is single node and the upgrade will be in the
same data center and same Linux server(Centos 7), just will run the ansible
to upgrade PG in all Data centers.
For examp
As we use ansible to deploy the upgrade, so mentioned the data centers
situation. The PostgreSQL is single node and the upgrade will be in the
same data center and same Linux server(Centos 7), just will run the ansible
to upgrade PG in all Data centers.
For example, in our aaa data center
postgre
Yi Sun writes:
> update pg_database set datcollate='en_US.UTF-8', datctype='en_US.UTF-8'
> where datname in ('postgres','template1','template0') and
> (datcollate<>'en_US.UTF-8' or datctype<>'en_US.UTF-8')
This seems like a pretty bad idea. You might get away with it if you've
not added any user
Hello,
We want to upgrade some PG9.6 DB to PG13, the databases locale are
different in data centers, some are C, some are ru_RU.UTF-8 and so on... as
below
postgres=# select datname,datcollate,datctype from pg_database;
datname| datcollate | datctype
Thank you for your response. Problem is resolved. I tried another way its
working fine.
Thank you so much
OBIREDDY. G
> It's a "oneclic "
>
> From here?:
>
> https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
>
> To get an answer you will need to provide as much basic informat
On 4/15/21 2:00 PM, obi reddy wrote:
It's a "oneclic "
From here?:
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
To get an answer you will need to provide as much basic information as
you can. So in addition to what you have provided we need:
1) Is the 9.6 instance a
It's a "oneclic "
>
> What was the source for the installs of the 9.6 and 10 instances of
> Postgres?:
>
> 1) RPM
> If so from what repo?
>
> 2) Other
> If so what and from where?
>
> >
> >
> >
> >
> > What is the actual OS?
> >
> > Where did you install 9.6 and 10 from?
> >
> >
On 4/15/21 10:49 AM, obi reddy wrote:
I have instal 10.0 side and OS is centos 6.4 64 bit
What was the source for the installs of the 9.6 and 10 instances of
Postgres?:
1) RPM
If so from what repo?
2) Other
If so what and from where?
What is the actual OS?
Where did you
I have instal 10.0 side and OS is centos 6.4 64 bit
>
>
>
> What is the actual OS?
>
> Where did you install 9.6 and 10 from?
>
> >
> > > When I am trying to upgrade 9.6 to 10 . I'M getting this error ,
> > please
> > > help me out
> >
> > What OS and version?
> >
> > Where d
On 4/15/21 10:33 AM, obi reddy wrote:
Yeah I have installed 10 and OS version is 6.4.
What is the actual OS?
Where did you install 9.6 and 10 from?
> When I am trying to upgrade 9.6 to 10 . I'M getting this error ,
please
> help me out
What OS and version?
Where did
Yeah I have installed 10 and OS version is 6.4.
> > When I am trying to upgrade 9.6 to 10 . I'M getting this error , please
> > help me out
>
> What OS and version?
>
> Where did you install Postgres from?
>
> >
> > pg_upgrade check for "/opt/postgresql/10/bin/passwd" failed: no such
> > file or d
On 4/15/21 9:43 AM, obi reddy wrote:
When I am trying to upgrade 9.6 to 10 . I'M getting this error , please
help me out
What OS and version?
Where did you install Postgres from?
pg_upgrade check for "/opt/postgresql/10/bin/passwd" failed: no such
file or directory failure, exiting
AFAIK
When I am trying to upgrade 9.6 to 10 . I'M getting this error , please
help me out
pg_upgrade check for "/opt/postgresql/10/bin/passwd" failed: no such file
or directory failure, exiting
13 matches
Mail list logo
