Comments (7)
jakob
commented on June 8, 2024
This is probably because of the new permission dialog we added in Postgres.app 2.7.
First of all, please make sure you are on the latest version of Postgres.app (currently 2.7.2)
Next, please open Postgres.app, go to settings, and check if Aqua Data Studio appears in the list of clients?
from postgresapp.
martinmueller39
commented on June 8, 2024
Thank you for your very prompt and clear response to my question!
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
from postgresapp.
jakob
commented on June 8, 2024
Are you still experiencing issues with Postgres.app and Aqua Data Studio?
Please let us know if you have been able to resolve the problem, or if you want us to further investigate the issue.
from postgresapp.
martinmueller39
commented on June 8, 2024
It seems to be working well. Thank you for your concern!
I cana’t remember whether I pushed some button or whether the app figured it out by itself. But I haven’t had any problems.
From: Jakob Egger ***@***.***>
Date: Friday, April 12, 2024 at 3:04 AM
To: PostgresApp/PostgresApp ***@***.***>
Cc: Martin Mueller ***@***.***>, Author ***@***.***>
Subject: Re: [PostgresApp/PostgresApp] gives wrong fatal error message (Issue #758)
Are you still experiencing issues with Postgres.app and Aqua Data Studio?
Please let us know if you have been able to resolve the problem, or if you want us to further investigate the issue.
—
Reply to this email directly, view it on GitHub<https://urldefense.com/v3/__https:/github.com/PostgresApp/PostgresApp/issues/758*issuecomment-2051231890__;Iw!!Dq0X2DkFhyF93HkjWTBQKhk!ThycVbqtL00bLb2jrTEuMbecc74fiWwzL43IEQPVrDTT-GzGr-OsKyr2WtYlJyhA2HIPcw7q8MHliKKxNki0jbfM6OIzxVOYYg$>, or unsubscribe<https://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/ABL7ULYQPGCGAJQ4YJHO4P3Y46IRVAVCNFSM6AAAAABFXK3346VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANJRGIZTCOBZGA__;!!Dq0X2DkFhyF93HkjWTBQKhk!ThycVbqtL00bLb2jrTEuMbecc74fiWwzL43IEQPVrDTT-GzGr-OsKyr2WtYlJyhA2HIPcw7q8MHliKKxNki0jbfM6OJ6ryTNKQ$>.
You are receiving this because you authored the thread.Message ID: ***@***.***>
from postgresapp.
martinmueller39
commented on June 8, 2024
I have a very stupid question for you. I can’t find the datafiles for my Postgres database. Which I think was installed with your app.
I am thinking of adding the data files to my Dropbox account, which means that in addition to being backed up on a separate drive via Time Machine they would also be retrievable if the drive crashed.
I assume that is a safe procedure, but I am still confused a little about how to do this. Right now, all my data are automatically backed up to /users/martinmueller/Dropbox, but all data stay on my machine. It isn’t clear to me whether or how I could add the various Postgress data files to that set up.
With thanks in advance for any help
Martin Mueller
Professor emeritus of English and Classics
Northwestern University
From: Jakob Egger ***@***.***>
Date: Friday, April 19, 2024 at 1:58 AM
To: PostgresApp/PostgresApp ***@***.***>
Cc: Martin Mueller ***@***.***>, Author ***@***.***>
Subject: Re: [PostgresApp/PostgresApp] gives wrong fatal error message (Issue #758)
Closed #758<https://urldefense.com/v3/__https:/github.com/PostgresApp/PostgresApp/issues/758__;!!Dq0X2DkFhyF93HkjWTBQKhk!XSoX4qNsSti3VLsCVJkqJTirNnarS6ok1PrM5QhmLh6hRHAxvFxCQFWaTQ6_AvXpL70ZgobesluCzW87_ofTUo8MSU0BQFS2PQ$> as completed.
—
Reply to this email directly, view it on GitHub<https://urldefense.com/v3/__https:/github.com/PostgresApp/PostgresApp/issues/758*event-12533580194__;Iw!!Dq0X2DkFhyF93HkjWTBQKhk!XSoX4qNsSti3VLsCVJkqJTirNnarS6ok1PrM5QhmLh6hRHAxvFxCQFWaTQ6_AvXpL70ZgobesluCzW87_ofTUo8MSU0GSGRGBQ$>, or unsubscribe<https://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/ABL7UL5AWQ6LBGXVN2HACQDY6C6ARAVCNFSM6AAAAABFXK3346VHI2DSMVQWIX3LMV45UABCJFZXG5LFIV3GK3TUJZXXI2LGNFRWC5DJN5XDWMJSGUZTGNJYGAYTSNA__;!!Dq0X2DkFhyF93HkjWTBQKhk!XSoX4qNsSti3VLsCVJkqJTirNnarS6ok1PrM5QhmLh6hRHAxvFxCQFWaTQ6_AvXpL70ZgobesluCzW87_ofTUo8MSU2FJNtVkw$>.
You are receiving this because you authored the thread.Message ID: ***@***.***>
from postgresapp.
jakob
commented on June 8, 2024
I can’t find the datafiles for my Postgres database.
The easiest way to find the data directory is to run the following query:
show data_directory;I am thinking of adding the data files to my Dropbox account, which means that in addition to being backed up on a separate drive via Time Machine they would also be retrievable if the drive crashed. I assume that is a safe procedure (...)
No! Do not put your data directory in Dropbox! There is a very high chance that this will corrupt your database. PostgreSQL doesn't like it when other apps manipulate its data directory, because then the different files will go out of sync.
Using TimeMachine on APFS to back up a PostgreSQL data directory is probably okay, because it uses file system snapshots. However, we haven't tested it. (If you do use time machine, make sure to always restore the full data directory, and do so only while the server is shut down.)
from postgresapp.
martinmueller39
commented on June 8, 2024
Many thanks for this excellent advice
From: Jakob Egger ***@***.***>
Date: Monday, May 27, 2024 at 10:26 AM
To: PostgresApp/PostgresApp ***@***.***>
Cc: Martin Mueller ***@***.***>, Author ***@***.***>
Subject: Re: [PostgresApp/PostgresApp] gives wrong fatal error message (Issue #758)
I can’t find the datafiles for my Postgres database.
The easiest way to find the data directory is to run the following query:
show data_directory;
I am thinking of adding the data files to my Dropbox account, which means that in addition to being backed up on a separate drive via Time Machine they would also be retrievable if the drive crashed. I assume that is a safe procedure (...)
No! Do not put your data directory in Dropbox! There is a very high chance that this will corrupt your database. PostgreSQL doesn't like it when other apps manipulate its data directory, because then the different files will go out of sync.
Using TimeMachine on APFS to back up a PostgreSQL data directory is probably okay, because it uses file system snapshots. However, we haven't tested it. (If you do use time machine, make sure to always restore the full data directory, and do so only while the server is shut down.)
—
Reply to this email directly, view it on GitHub<https://urldefense.com/v3/__https:/github.com/PostgresApp/PostgresApp/issues/758*issuecomment-2133694271__;Iw!!Dq0X2DkFhyF93HkjWTBQKhk!VdIS9DdAVLJjheRXne4Jznd7bFBkhujvYEtu0ONNkKVRQPJNBDVNH24eDDdju8ey-jKRILqe-s766PPdA7iMqW9usMNA-8YUZQ$>, or unsubscribe<https://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/ABL7UL6BJYOJEZHH23PQO3TZENF7ZAVCNFSM6AAAAABFXK3346VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMZTGY4TIMRXGE__;!!Dq0X2DkFhyF93HkjWTBQKhk!VdIS9DdAVLJjheRXne4Jznd7bFBkhujvYEtu0ONNkKVRQPJNBDVNH24eDDdju8ey-jKRILqe-s766PPdA7iMqW9usMNsOm_ODw$>.
You are receiving this because you authored the thread.Message ID: ***@***.***>
from postgresapp.
Related Issues (20)
- Add a helper script to ease path configuration
- Improve Database listing
- Probe different credentials to list databases HOT 2
- Storing the Database on an external drive HOT 1
- Ensure app window is active and selected by default HOT 4
- Support for more client apps HOT 4
- Add gdal_polygonize to command line tools
- pgAdmin 4 detects prior PostgreSQL which no longer exists HOT 2
- Postgres.app failed to verify "trust" authentication HOT 30
- Sync logic for `auth_permission_dialog.dialog_executable_path` with binary path logic HOT 1
- TimescaleDB CMake Error HOT 2
- Disabling Permission Dialog is not respected by MenuHelper / Autostart HOT 5
- Update Error! Try again later. HOT 3
- standardize_address not accurate HOT 3
- job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: Permission denied HOT 1
- The auth_permission_dialog extension wasn't found. HOT 3
- What's the best way to grab the binaries to embed in, say, an Electron app? HOT 2
- postgreSQL downloard error HOT 2
- Existing data directory found during postgres installation HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from postgresapp.