Search Postgresql Archives

Re: Getting error while upgrading postgres from version 12 to 13

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 3/21/23 03:29, shashidhar Reddy wrote:
Actually I was using the below command to check the compatibility, it worked without any issue with 12.6 but it is not working with 1version 2.14 time /usr/lib/postgresql/13/bin/pg_upgrade --old-bindir /usr/lib/postgresql/12/bin --new-bindir /usr/lib/postgresql/13/bin --old-datadir /usr/pgdata/pg_data --new-datadir /usr/pgdata/pg_data2 --link --check

I have used a different directory for postgres13 from postgres 12.

The issue is not that they are the same directory it is:

FATAL:  database files are incompatible with server
 DETAIL:  The data directory was initialized by PostgreSQL version 13
, which is not compatible with this version 12.14 (Ubuntu
12.14-1.pgdg18.04+1)

Check the value that is the PG_VERSION file in each data directory. It should be 12 in /usr/pgdata/pg_data and 13 in /usr/pgdata/pg_data2.


On Mon, Mar 20, 2023 at 11:07 AM <abdulsayeed24@xxxxxxxxx <mailto:abdulsayeed24@xxxxxxxxx>> wrote:

    Hello,

    As per error it seems you have initiated source data with PG13
    binaries.

    Could you please connect to both source and target psql and share
    out of select versions();

    Also share pg_upgrade complete command which you are using.



    Regards,
    Abdul Sayeed



    Sent from myMail for iOS


    Sunday, 19 March 2023 at 11:29 AM +0530 from
    david.g.johnston@xxxxxxxxx <mailto:david.g.johnston@xxxxxxxxx>
    <david.g.johnston@xxxxxxxxx <mailto:david.g.johnston@xxxxxxxxx>>:

        On Sat, Mar 18, 2023 at 7:27PM shashidhar Reddy
        <shashidharreddy001@xxxxxxxxx
        <mailto:shashidharreddy001@xxxxxxxxx>> wrote:

            Can someone please help me with this?



You haven't given others enough information to help you. Present to the fullest extent possible your current environment
        and the commands you are running.  Showing that psql itself
        works on both running clusters would be a good start.  Show
        inputs, not just outputs those inputs creates.

        David J.



--
Shashidhar

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux