Unable to Backup Database on Mac

[RWPKRPLR]

Trying to backup my database on my mac to transfer it to my pc, but I seem to be missing a file… this is what comes up…

PostgreSQL version 14.7 on aarch64-apple-darwin20.6.0 is installed. it is recommended to upgrade to at least version 8.3 for backup/restoe.

then it lets me proceed to select a folder to save to…

followed by… Can’t Find: /Library/PostgreSQL/14.7 on aarch64-apple-darwin20.6/bin/pg_dump
This file is normally contained in /Library/PostgreSQL/x.x/bin. if you are using a remote install of PostgreSQL, you will need to install PostgreSQL on your local computer or, if possible and compatible, find this application on the server.

Have any ideas?

Please note i have alredy tried to update PostgreSQL.

Thank you,
Ryan

[Flag_Hippo]

Please turn on 'Enable Logging' in PokerTracker 4 via 'Configure -> Options' and then restart PokerTracker 4. Next reproduce this issue and then attach your support bundle to a Support Ticket where a technician can give you further guidance. The support bundle is created via the 'File -> Create Support Bundle' menu option in PokerTracker 4.

[RWPKRPLR]

Thank you.

I ended up using the Pg_Dump file in the PostgreSQL 10 File folder.

It allowed me to backup my processed hands but with errors. I then went to restore them on my new computer, but it wouldn't do anything. I followed this up with just importing from disk and boom I was able to import all my processed hands.

[parkarama]

Many things changed between PG10 & PG14, I'm not surprised pg_dump has trouble restoring PG14 dumps. The PG10 psql client may still work just fine if the protocol didn't change. Anyway, using the most most recent tools to access an older database engine will usually work better than doing it the other way.

Make sure you don't use the path of pg_dump that uses symbolic links. PT4 doesn't seem to solve the symbolic links that are usually used to mask the subversion components of the tools paths.

The pg_xxx commands presented to the user are usually symbolic links links to the actual binaries whose path will often have version and subversion infos in it.

For example, I use PostgreSQL 15 installed with Homebrew packages postgresql-common and postgresql@15.
When I look for the path of the pg_dump command from a shell, I get the generic link offered by postgresql-common :

Code: Select all

% type pg_dump
pg_dump is /opt/homebrew/bin/pg_dump


It is actually a link to the pg_wrapper command of the PostgreSQL-common package, which will eventually redirect to /opt/homebrew/Cellar/postgresql@15/15.5/bin/pg_dump ; I gave this path to PT4 when it asked for pg_dump.

Whenever postgresql@15 package will change minor version, I'll have to point to the new file.

You seem to use the EDB packaging of postgresql for macOS, the path will be different but the logic should be the same.

[sbeales]

/Applications/Postgres.app/Contents/Versions/10/bin is the location for pg_dump using the EDB installer for macOS.

Although I see the mistaken pop up error about upgrading my version of Postgres every time, I have no other issues using backup through PokerTracker database management with EDB Postgres once the correct pg_dump has been selected.

Hope that helps.