pgAdmin 4 and PostGresSQL 11

[RyanPlanteNJ]

Having problems showing the database when trying to connect PostGres to Atom. Have the .tar file connected to pgAdmin 4 server. How do I translate this to Atom? Would be very beneficial to just be able to have everything in one spot.

[lukemurray]

I'm not really sure what you're trying to do here. Pgadmin is a tool that allows you to connect and run queries against postgres.

Data-atom also connects to postgres and let's you run queries etc.

What is the tar file? If a DB backup, data atom doesn't do anything with that. You could use of command to restore the db then connect to the database.

Can you provide anymore information on what you want to achieve?

---

From: RyanPlanteNJ notifications@github.com Sent: Monday, March 25, 2019 1:09 pm To: lukemurray/data-atom Cc: Subscribed Subject: [lukemurray/data-atom] pgAdmin 4 and PostGresSQL 11 (#171)

Having problems showing the database when trying to connect PostGres to Atom. Have the .tar file connected to pgAdmin 4 server. How do I translate this to Atom? Would be very beneficial to just be able to have everything in one spot.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://github.com/lukemurray/data-atom/issues/171, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AAJj0YQsgph7FFMQewS2oMopLs7b_6Grks5vaC--gaJpZM4cF7id.

[RyanPlanteNJ]

i have my tar file in my downloads folder. i want to be able to use that tar file in atom and be able to use data-atom to pull information from that tar file. sorry for not being clear. I have a tendency to do that :/

[lukemurray]

Sorry, Data-Atom does not support query data from a tar file. If the tar file contains a postgres DB, you'll have to use the pg tools to restore the backup file to an actual running postgres DB and connect data atom to that.

[RyanPlanteNJ]

It does have a DB. It has all sorts of tables and columns and all that good stuff. Do I to add it to pgadmin first (which I did) and then connect pgadmin to atom? And if so, how? I tried using server number (127.0.0.1) along with everything that made sense but it never showed the DB On Mar 26, 2019, 6:04 AM -0400, Luke Murray notifications@github.com, wrote:

Sorry, Data-Atom does not support query data from a tar file. If the tar file contains a postgres DB, you'll have to use the pg tools to restore the backup file to an actual running postgres DB and connect data atom to that. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

[lukemurray]

Sorry, I'm not sure how I can help you here.

I have zero experience with pgadmin. I don't think you can connect pgadmin to atom, that I know of.

It sounds like you want to restore the tar file (containing a DB backup) to a running PG server. I would use the PG command line (https://www.postgresql.org/docs/9.1/backup.html). Data atom doesn't have support for restoring backups.

Data atom just connects to a running PG server.

[RyanPlanteNJ]

Ah ok gotcha. I'll try using the command line function for PGSQL 11 and see if I cant get it to work. Thank you anyway!

_{Sent with GitHawk}

[lukemurray]

Now that is interesting. What OS? How have you installed postgres? I can connect to postgres 11 fine. Anything else you can tell me about your set up?

---

From: RyanPlanteNJ notifications@github.com Sent: Wednesday, March 27, 2019 1:08 pm To: lukemurray/data-atom Cc: Luke Murray; State change Subject: Re: [lukemurray/data-atom] pgAdmin 4 and PostGresSQL 11 (#171)

Ok so i was able to drill down the issue and it looks like my database IS in PG. I confirmed this using the command line and using \l to see all listed databases. it is in there and i set up a user name with what my current user name on this computer is. I even used a simple password but it keeps kicking back saying it wasnt able to authenticate it so i am not able to connect to the database for some reason

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHubhttps://github.com/lukemurray/data-atom/issues/171#issuecomment-476935015, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AAJj0X-xCHXSeesVII5qdldrRgL5yL-zks5vatKDgaJpZM4cF7id.

[RyanPlanteNJ]

Come to find out i was being a dunce. its all good now. i was making things way to complicated. lol

On Wed, Apr 3, 2019 at 5:55 AM Luke Murray notifications@github.com wrote:

Now that is interesting. What OS? How have you installed postgres? I can connect to postgres 11 fine. Anything else you can tell me about your set up?

---

From: RyanPlanteNJ notifications@github.com Sent: Wednesday, March 27, 2019 1:08 pm To: lukemurray/data-atom Cc: Luke Murray; State change Subject: Re: [lukemurray/data-atom] pgAdmin 4 and PostGresSQL 11 (#171)

Ok so i was able to drill down the issue and it looks like my database IS in PG. I confirmed this using the command line and using \l to see all listed databases. it is in there and i set up a user name with what my current user name on this computer is. I even used a simple password but it keeps kicking back saying it wasnt able to authenticate it so i am not able to connect to the database for some reason

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub< https://github.com/lukemurray/data-atom/issues/171#issuecomment-476935015>, or mute the thread< https://github.com/notifications/unsubscribe-auth/AAJj0X-xCHXSeesVII5qdldrRgL5yL-zks5vatKDgaJpZM4cF7id

.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/lukemurray/data-atom/issues/171#issuecomment-479421803, or mute the thread https://github.com/notifications/unsubscribe-auth/AEspYAdlyTykuwgENzrciC-MJg06qe2Cks5vdHqWgaJpZM4cF7id .