PostgreSQL help
I have successfully setup a runRev application to work with PosgreSQL on localhost of the same machine that is running the runRev app (OS X). Now I am ready to connect to a fresh PostgreSQL install on a Vista machine on the LAN. I am trying to use Navicat to move the database from the localhost to the new server installation. I can¹t make the connection. I can ping from one machine to the other, but I can¹t get a response from Postgres. The services are running. Any ideas as to what might be wrong? I know that this is a very basic question with a lot of variables to the specific installations here, but I need to learn how to do this smoothly and easily. I expect to host many, many of these Postgres database on hosted installations, perhaps virtual servers, on the net. Any guidance would be appreciated and any reference works for my education would be appreciated also. I am an experienced database user. I am familiar with MS SQL Server, Openbase, Frontbase, and SQLite. This is my first time with Postgres. Thanks, -- Alex Adams hawkVision tools for solving Wicked Problems (a)2 Technology Partners, Inc. 831-726-8013 a...@a2tecnology.com www.a2technology.com www.promisstudio.com universalconnector.wordpress.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: PostgreSQL help
Hi, Did you set-up your remote PostgreSQL to accept non-localhost connexions too (hba.conf) ? Best, Le 14 janv. 10 à 18:56, Alex Adams a écrit : I have successfully setup a runRev application to work with PosgreSQL on localhost of the same machine that is running the runRev app (OS X). Now I am ready to connect to a fresh PostgreSQL install on a Vista machine on the LAN. I am trying to use Navicat to move the database from the localhost to the new server installation. I can’t make the connection. I can ping from one machine to the other, but I can’t get a response from Postgres. The services are running. Any ideas as to what might be wrong? I know that this is a very basic question with a lot of variables to the specific installations here, but I need to learn how to do this smoothly and easily. I expect to host many, many of these Postgres database on hosted installations, perhaps virtual servers, on the net. Any guidance would be appreciated and any reference works for my education would be appreciated also. I am an experienced database user. I am familiar with MS SQL Server, Openbase, Frontbase, and SQLite. This is my first time with Postgres. Thanks, -- Alex Adams hawkVision — tools for solving Wicked Problems (a)2 Technology Partners, Inc. 831-726-8013 a...@a2tecnology.com www.a2technology.com www.promisstudio.com universalconnector.wordpress.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- Pierre Sahores mobile : (33) 6 03 95 77 70 www.wrds.com www.sahores-conseil.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: PostgreSQL help
Pierre, Unknown. How do I do that? Thanks, -- Alex Adams hawkVision tools for solving Wicked Problems (a)2 Technology Partners, Inc. 831-726-8013 a...@a2tecnology.com www.a2technology.com www.promisstudio.com universalconnector.wordpress.com From: Pierre Sahores psaho...@free.fr Reply-To: How to use Revolution use-revolution@lists.runrev.com Date: Thu, 14 Jan 2010 19:08:25 +0100 To: How to use Revolution use-revolution@lists.runrev.com Subject: Re: PostgreSQL help Hi, Did you set-up your remote PostgreSQL to accept non-localhost connexions too (hba.conf) ? Best, Le 14 janv. 10 à 18:56, Alex Adams a écrit : I have successfully setup a runRev application to work with PosgreSQL on localhost of the same machine that is running the runRev app (OS X). Now I am ready to connect to a fresh PostgreSQL install on a Vista machine on the LAN. I am trying to use Navicat to move the database from the localhost to the new server installation. I can¹t make the connection. I can ping from one machine to the other, but I can¹t get a response from Postgres. The services are running. Any ideas as to what might be wrong? I know that this is a very basic question with a lot of variables to the specific installations here, but I need to learn how to do this smoothly and easily. I expect to host many, many of these Postgres database on hosted installations, perhaps virtual servers, on the net. Any guidance would be appreciated and any reference works for my education would be appreciated also. I am an experienced database user. I am familiar with MS SQL Server, Openbase, Frontbase, and SQLite. This is my first time with Postgres. Thanks, -- Alex Adams hawkVision tools for solving Wicked Problems (a)2 Technology Partners, Inc. 831-726-8013 a...@a2tecnology.com www.a2technology.com www.promisstudio.com universalconnector.wordpress.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- Pierre Sahores mobile : (33) 6 03 95 77 70 www.wrds.com www.sahores-conseil.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: PostgreSQL help
See inside your windows PostgreSQL directory where to find the Pg_hba.conf file and just add your navicat host IP as a trusted host. http://www.mapbender.org/Pg_hba.conf http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html The Pg_hba.conf file is, by default, set to accept localhost connexions only. Best, Le 14 janv. 10 à 19:17, Alex Adams a écrit : Pierre, Unknown. How do I do that? Thanks, -- Alex Adams hawkVision — tools for solving Wicked Problems (a)2 Technology Partners, Inc. 831-726-8013 a...@a2tecnology.com www.a2technology.com www.promisstudio.com universalconnector.wordpress.com From: Pierre Sahores psaho...@free.fr Reply-To: How to use Revolution use-revolution@lists.runrev.com Date: Thu, 14 Jan 2010 19:08:25 +0100 To: How to use Revolution use-revolution@lists.runrev.com Subject: Re: PostgreSQL help Hi, Did you set-up your remote PostgreSQL to accept non-localhost connexions too (hba.conf) ? Best, Le 14 janv. 10 à 18:56, Alex Adams a écrit : I have successfully setup a runRev application to work with PosgreSQL on localhost of the same machine that is running the runRev app (OS X). Now I am ready to connect to a fresh PostgreSQL install on a Vista machine on the LAN. I am trying to use Navicat to move the database from the localhost to the new server installation. I can’t make the connection. I can ping from one machine to the other, but I can’t get a response from Postgres. The services are running. Any ideas as to what might be wrong? I know that this is a very basic question with a lot of variables to the specific installations here, but I need to learn how to do this smoothly and easily. I expect to host many, many of these Postgres database on hosted installations, perhaps virtual servers, on the net. Any guidance would be appreciated and any reference works for my education would be appreciated also. I am an experienced database user. I am familiar with MS SQL Server, Openbase, Frontbase, and SQLite. This is my first time with Postgres. Thanks, -- Alex Adams hawkVision — tools for solving Wicked Problems (a)2 Technology Partners, Inc. 831-726-8013 a...@a2tecnology.com www.a2technology.com www.promisstudio.com universalconnector.wordpress.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- Pierre Sahores mobile : (33) 6 03 95 77 70 www.wrds.com www.sahores-conseil.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- Pierre Sahores mobile : (33) 6 03 95 77 70 www.wrds.com www.sahores-conseil.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: PostgreSQL help
I read a little, edited the hba.conf file and got it to work for this installation on Vista. Where is the hba.conf file found on the Mac? -- Alex Adams hawkVision tools for solving Wicked Problems (a)2 Technology Partners, Inc. 831-726-8013 a...@a2tecnology.com www.a2technology.com www.promisstudio.com universalconnector.wordpress.com From: Alex Adams a...@a2technology.com Reply-To: How to use Revolution use-revolution@lists.runrev.com Date: Thu, 14 Jan 2010 10:17:41 -0800 To: How to use Revolution use-revolution@lists.runrev.com Subject: Re: PostgreSQL help Pierre, Unknown. How do I do that? Thanks, -- Alex Adams hawkVision tools for solving Wicked Problems (a)2 Technology Partners, Inc. 831-726-8013 a...@a2tecnology.com www.a2technology.com www.promisstudio.com universalconnector.wordpress.com From: Pierre Sahores psaho...@free.fr Reply-To: How to use Revolution use-revolution@lists.runrev.com Date: Thu, 14 Jan 2010 19:08:25 +0100 To: How to use Revolution use-revolution@lists.runrev.com Subject: Re: PostgreSQL help Hi, Did you set-up your remote PostgreSQL to accept non-localhost connexions too (hba.conf) ? Best, Le 14 janv. 10 à 18:56, Alex Adams a écrit : I have successfully setup a runRev application to work with PosgreSQL on localhost of the same machine that is running the runRev app (OS X). Now I am ready to connect to a fresh PostgreSQL install on a Vista machine on the LAN. I am trying to use Navicat to move the database from the localhost to the new server installation. I can¹t make the connection. I can ping from one machine to the other, but I can¹t get a response from Postgres. The services are running. Any ideas as to what might be wrong? I know that this is a very basic question with a lot of variables to the specific installations here, but I need to learn how to do this smoothly and easily. I expect to host many, many of these Postgres database on hosted installations, perhaps virtual servers, on the net. Any guidance would be appreciated and any reference works for my education would be appreciated also. I am an experienced database user. I am familiar with MS SQL Server, Openbase, Frontbase, and SQLite. This is my first time with Postgres. Thanks, -- Alex Adams hawkVision tools for solving Wicked Problems (a)2 Technology Partners, Inc. 831-726-8013 a...@a2tecnology.com www.a2technology.com www.promisstudio.com universalconnector.wordpress.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- Pierre Sahores mobile : (33) 6 03 95 77 70 www.wrds.com www.sahores-conseil.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: PostgreSQL help
Alex, Here is my home dev config MacMini one (OS X 10.4) /usr/local/pgsql/data/pg_hba.conf Best, Pierre Le 14 janv. 10 à 20:06, Alex Adams a écrit : I read a little, edited the hba.conf file and got it to work for this installation on Vista. Where is the hba.conf file found on the Mac? -- Alex Adams hawkVision — tools for solving Wicked Problems (a)2 Technology Partners, Inc. 831-726-8013 a...@a2tecnology.com www.a2technology.com www.promisstudio.com universalconnector.wordpress.com From: Alex Adams a...@a2technology.com Reply-To: How to use Revolution use-revolution@lists.runrev.com Date: Thu, 14 Jan 2010 10:17:41 -0800 To: How to use Revolution use-revolution@lists.runrev.com Subject: Re: PostgreSQL help Pierre, Unknown. How do I do that? Thanks, -- Alex Adams hawkVision — tools for solving Wicked Problems (a)2 Technology Partners, Inc. 831-726-8013 a...@a2tecnology.com www.a2technology.com www.promisstudio.com universalconnector.wordpress.com From: Pierre Sahores psaho...@free.fr Reply-To: How to use Revolution use-revolution@lists.runrev.com Date: Thu, 14 Jan 2010 19:08:25 +0100 To: How to use Revolution use-revolution@lists.runrev.com Subject: Re: PostgreSQL help Hi, Did you set-up your remote PostgreSQL to accept non-localhost connexions too (hba.conf) ? Best, Le 14 janv. 10 à 18:56, Alex Adams a écrit : I have successfully setup a runRev application to work with PosgreSQL on localhost of the same machine that is running the runRev app (OS X). Now I am ready to connect to a fresh PostgreSQL install on a Vista machine on the LAN. I am trying to use Navicat to move the database from the localhost to the new server installation. I can’t make the connection. I can ping from one machine to the other, but I can’t get a response from Postgres. The services are running. Any ideas as to what might be wrong? I know that this is a very basic question with a lot of variables to the specific installations here, but I need to learn how to do this smoothly and easily. I expect to host many, many of these Postgres database on hosted installations, perhaps virtual servers, on the net. Any guidance would be appreciated and any reference works for my education would be appreciated also. I am an experienced database user. I am familiar with MS SQL Server, Openbase, Frontbase, and SQLite. This is my first time with Postgres. Thanks, -- Alex Adams hawkVision — tools for solving Wicked Problems (a)2 Technology Partners, Inc. 831-726-8013 a...@a2tecnology.com www.a2technology.com www.promisstudio.com universalconnector.wordpress.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- Pierre Sahores mobile : (33) 6 03 95 77 70 www.wrds.com www.sahores-conseil.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- Pierre Sahores mobile : (33) 6 03 95 77 70 www.wrds.com www.sahores-conseil.com ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution