but when I try to connect to external server (as it works in psql), it gives me an outright segmentation fault. Server version is PostgreSQL 11.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.3 20140911 (Red Hat 4.8.3-9), 64-bit.
Can it be just due to version mismatch? What are the reasons for us not to be able to have pgadmin4 on nixos?
I only created an account here to thank you, I tried the normal way of installing postgres on my mac through the .dmg package where both postgresql and pgadmin are bundled togther and hit this issue: stackoverflow.com/questions/591897...
The PostgreSQL Global Development Group (PGDG) maintains an APT repository of PostgreSQL packages for Debian and Ubuntu located at We aim at building PostgreSQL server packages as well as extensions and modules packages on several Debian/Ubuntu releases for all PostgreSQL versions supported.Currently, we supportDebian 6.0 (squeeze), 7.0 (wheezy), and unstable (sid) 64/32 bit (amd64/i386)Ubuntu 10.04 (lucid), 12.04 (precise), 13.10 (saucy), 14.04 (trusty) 64/32 bit (amd64/i386)PostgreSQL 8.4, 9.0, 9.1, 9.2, 9.3, 9.4 betaServer extensions such as Slony-I, various PL languages, and datatypesApplications like pgadmin3, pgbouncer, and pgpool-IIPackages for older PostgreSQL versions and older Debian/Ubuntu distributions will continue to stay in the repository; updates for those will be provided on an ad-hoc basis.
Hello, I am doing data aggregation using Postgresql (pgadmin). I just finished the query and my results look good. However, I can't see my results from ArcGIS Pro. So, how should I proceed to register my results so I can see from ArcGIS Pro?
Hello! I have created a database on pgadmin, and when trying to access the exported database from another machine/linux server, it gives this error "could not input file..." I have attached a picture of the error. I have also double-checked the paths that the database points to and where it is on the machine/server and they do match, so i'm a little lost. HALP! :)
RIght, so the database was originally created on windows 10 on my local machine. Its trying to be accessed from a remote machine with a linux server. I exported with pgadmin and shared the file to the remote machine.
How exactly did you do the export? What were the options used? I think there is a mismatch between the format. You specified --format=d in the pg_restore command which indicates a directory format dump, however I suspect you just have a single file that pgadmin created for you. The file you're using is named .sql but it's probably in reality a TAR file (kind of like a zip file). What pg_restore is trying to do is find a directory (folder) called MCAFEE1.SQL and fails because it's a file, not a folder.