[GENERAL] Connecting matlab with postgresql

Hi, You could use PgMex (http://pgmex.alliedtesting.com/) - high-performance PostgreSQL client library for Matlab that enables a Matlab-based application to communicate with PostgreSQL database in the Matlab native way by passing data in a form of matrices, multi-dimensional arrays and

Re: [GENERAL] Connecting to SQL Server from Windows using FDW

Hi John, Thanks, but I already saw that link. The problem is to installing the tds_fwd extension on postgres. And I don't know how to (never tried) compile it... What comes with postgres by default is the postgres fdw , that allow

Re: [GENERAL] Connecting to SQL Server from Windows using FDW

> On 23 January 2016 at 04:40, John J. Turner wrote: > On Jan 22, 2016, at 1:05 PM, ivo silvestre wrote: > > > I need to create a linked server between 2 Windows servers. In one I've > > PostgreSQL with admin privileges and in the other MS SQL with only

Re: [GENERAL] Connecting to SQL Server from Windows using FDW

On 01/22/2016 10:05 AM, ivo silvestre wrote: Hi, I need to create a linked server between 2 Windows servers. In one I've PostgreSQL with admin privileges and in the other MS SQL with only read access. I need to create a view (or a foreign table?) in PostgreSQL from a table in MS SQL in another

[GENERAL] Connecting to SQL Server from Windows using FDW

Hi, I need to create a linked server between 2 Windows servers. In one I've PostgreSQL with admin privileges and in the other MS SQL with only read access. I need to create a view (or a foreign table?) in PostgreSQL from a table in MS SQL in another server. The table in the MS SQL is constantly

Re: [GENERAL] Connecting to SQL Server from Windows using FDW

On Jan 22, 2016, at 1:05 PM, ivo silvestre wrote: > I need to create a linked server between 2 Windows servers. In one I've > PostgreSQL with admin privileges and in the other MS SQL with only read > access. > > I need to create a view (or a foreign table?) in PostgreSQL

Re: [GENERAL] Connecting to 2 different DB on same machine

On 04/22/2015 10:49 AM, puneet252002 wrote: Hi Team, I am running in a confusion on how to connect two different database at different path. 1. Default PostgreSQL DB 2. ManageEngine Servicedesk Plus DB I have installed PostgreSQL for windows successfully and connected to default database of

Re: [GENERAL] Connecting to 2 different DB on same machine

On 4/22/2015 10:49 AM, puneet252002 wrote: Hi Team, I am running in a confusion on how to connect two different database at different path. 1. Default PostgreSQL DB 2. ManageEngine Servicedesk Plus DB I have installed PostgreSQL for windows successfully and connected to default database of

[GENERAL] Connecting to 2 different DB on same machine

Hi Team,I am running in a confusion on how to connect two different database at different path. 1. Default PostgreSQL DB2. ManageEngine Servicedesk Plus DBI have installed PostgreSQL for windows successfully and connected to default database of PostgreSQL. Now I to connect ManageEngine Servicedesk

Re: [GENERAL] Connecting with PostgreSQL 9.1 using the Ubuntu machine user and peer authentication method

On Thu, Aug 7, 2014 at 3:43 PM, Adrian Klaver adrian.kla...@aklaver.com wrote: On 08/07/2014 01:39 AM, Jorge Arevalo wrote: What OS are you on? Per: http://www.postgresql.org/__docs/9.1/interactive/auth-__ methods.html#AUTH-PEER

Re: [GENERAL] Connecting with PostgreSQL 9.1 using the Ubuntu machine user and peer authentication method

On Thu, Aug 7, 2014 at 1:14 AM, Adrian Klaver adrian.kla...@aklaver.com wrote: On 08/06/2014 03:43 PM, Jorge Arevalo wrote: Hello, I want to connect to my local installation of PostgreSQL 9.1 using my machine user (who is vagrant). So, after reading PostgreSQL documentation, I thought I

Re: [GENERAL] Connecting with PostgreSQL 9.1 using the Ubuntu machine user and peer authentication method

On Thu, Aug 7, 2014 at 1:08 AM, John R Pierce pie...@hogranch.com wrote: On 8/6/2014 3:43 PM, Jorge Arevalo wrote: I want to connect to my local installation of PostgreSQL 9.1 using my machine user (who is vagrant). So, after reading PostgreSQL documentation, I thought I just needed to:

Re: [GENERAL] Connecting with PostgreSQL 9.1 using the Ubuntu machine user and peer authentication method

On Aug 6, 2014, at 6:56 PM, Frank Pinto fr...@ayalo.co wrote: and make sure you restarted the server so your changes take effect. reload will get it, also, and is sometimes easier to come by. The pg_hba.conf file is read on start-up and when the main server process receives a SIGHUP

Re: [GENERAL] Connecting with PostgreSQL 9.1 using the Ubuntu machine user and peer authentication method

On 08/07/2014 01:39 AM, Jorge Arevalo wrote: What OS are you on? Per: http://www.postgresql.org/__docs/9.1/interactive/auth-__methods.html#AUTH-PEER http://www.postgresql.org/docs/9.1/interactive/auth-methods.html#AUTH-PEER Peer authentication is only available on

[GENERAL] Connecting with PostgreSQL 9.1 using the Ubuntu machine user and peer authentication method

Hello, I want to connect to my local installation of PostgreSQL 9.1 using my machine user (who is vagrant). So, after reading PostgreSQL documentation, I thought I just needed to: 1. Add username map in pg_ident.conf: # MAPNAME SYSTEM-USERNAME PG-USERNAME vp

Re: [GENERAL] Connecting with PostgreSQL 9.1 using the Ubuntu machine user and peer authentication method

Looks like you're doing it right, you actually have to specify the user though: psql -U postgres and make sure you restarted the server so your changes take effect. Frank On Wed, Aug 6, 2014 at 4:43 PM, Jorge Arevalo jorgearev...@libregis.org wrote: Hello, I want to connect to my local

Re: [GENERAL] Connecting with PostgreSQL 9.1 using the Ubuntu machine user and peer authentication method

On 8/6/2014 3:43 PM, Jorge Arevalo wrote: I want to connect to my local installation of PostgreSQL 9.1 using my machine user (who is vagrant). So, after reading PostgreSQL documentation, I thought I just needed to: wouldn't it be easier to ... create user vagrant superuser;

Re: [GENERAL] Connecting with PostgreSQL 9.1 using the Ubuntu machine user and peer authentication method

On 08/06/2014 03:43 PM, Jorge Arevalo wrote: Hello, I want to connect to my local installation of PostgreSQL 9.1 using my machine user (who is vagrant). So, after reading PostgreSQL documentation, I thought I just needed to: 1. Add username map in pg_ident.conf: # MAPNAME

[GENERAL] Connecting Multiple LibreOffice Base Users to a Remote Postgres Database

Hi all, I have been posting on my blog about getting LibreOffice Base and PostgreSQL working together. My latest actually focuses on getting multiple users connecting to a single, remote, stand-alone PostgreSQL server. You can set this up fairly quickly and - in my case, anyway - with no

[GENERAL] Connecting to Postgres using Windows 7

I'm relatively new to postgres. I've got a Visual Basic (VB) application that i would like to connect to a Postgres database using ODBC . Both the VB application and postgres are on my laptop and both work beautifully independent of each other. Trouble is, I have a windows 7 64bit OS and

Re: [GENERAL] Connecting to Postgres using Windows 7

On 05/25/2011 09:49 PM, Geoffrey Becker wrote: When I try to connect, all I get is a Server does not exist or access is denied error. I've tried configuring ODBC using odbcad32.exe as it seems that is necessary on a 64 bit OS, but I'm not sure if that even the right way to go. *which*

Re: [GENERAL] Connecting to Postgres using Windows 7

- Original Message - From: Geoffrey Becker I'm relatively new to postgres. I've got a Visual Basic (VB) application that i would like to connect to a Postgres database using ODBC . Both the VB application and postgres are on my laptop and both work beautifully independent of each

[GENERAL] Connecting to Postgres using Windows 7

I'm relatively new to postgres. I've got a Visual Basic (VB) application that i would like to connect to a Postgres database using ODBC . Both the VB application and postgres are on my laptop and both work beautifully independent of each other. Trouble is, I have a windows 7 64bit OS and

[GENERAL] Connecting matlab with postgresql

Hello nice people, I am sure many of you have idea about how to connect matlab with postgresql. Connecting with matab database toolbox is possible which i have not tried yet because i dont have access to that toolbox. I have read in internet that its possible to connect without having a

Re: [GENERAL] Connecting matlab with postgresql

Sukuchha Shrestha sukuchha at yahoo.de writes: Could anybody explain here how to connect in a detailed step ! Consider me studying in class 1 of postgresql when explaining :) It may not be much help to you, but on a Unix shell I tend to run psql through some text manipulation pipes and then

Re: [GENERAL] Connecting to Teradata via Postgresql

On Sun, 2009-08-30 at 23:21 +0800, Ow Mun Heng wrote: Anyone here has a teradata box ? Are you able to connect to it from withing postgresql? I would like to pull 1or 2 tables from the box (sync) and was wondering if there's anyway to do that w/o using dbi-link. I actually am trying

[GENERAL] Connecting to Teradata via Postgresql

Hi All, Anyone here has a teradata box ? Are you able to connect to it from withing postgresql? I would like to pull 1or 2 tables from the box (sync) and was wondering if there's anyway to do that w/o using dbi-link. I actually am trying dbi-link but it seem as though it doesn't support

Re: [GENERAL] Connecting to Teradata via Postgresql

On Sun, Aug 30, 2009 at 11:21:55PM +0800, Ow Mun Heng wrote: Hi All, Anyone here has a teradata box? Are you able to connect to it from withing postgresql? If you can get me a test environment including Teradata, I'd be delighted to add support to DBI-Link, most likely in the form of

Re: [GENERAL] connecting to a remote pq always require a password

On 2009-06-18, David Shen davidshe...@googlemail.com wrote: Hi, I am trying to use the libpq to connect to my postgresql 8.3 server. If I use dbname = mydb, the connection made successfully because I am using a socket connection. But if I use host = 127.0.0.1 dbname = mydb, the error message

[GENERAL] connecting to a remote pq always require a password

Hi, I am trying to use the libpq to connect to my postgresql 8.3 server. If I use dbname = mydb, the connection made successfully because I am using a socket connection. But if I use host = 127.0.0.1 dbname = mydb, the error message is no password supplied. In the pg_hba.conf file, I even change

Re: [GENERAL] connecting to a remote pq always require a password

On Jun 18, 2009, at 8:11 AM, David Shen wrote: In the pg_hba.conf file, I even change the host access control to this: hostall all 127.0.0.1/32 trust but it still does not work. What I missed? Did you reload the configuration (or restart the sever) after

Re: [GENERAL] connecting to a remote pq always require a password

--- On Thu, 6/18/09, David Shen davidshe...@googlemail.com wrote: From: David Shen davidshe...@googlemail.com Subject: [GENERAL] connecting to a remote pq always require a password To: pgsql-general@postgresql.org Date: Thursday, June 18, 2009, 12:11 PM Hi, I am trying to use the libpq

Re: [GENERAL] Connecting to a postgreSQL database with windows CE over wi-fi; failing gracefully

Peter Geoghegan peter.geoghega...@gmail.com writes: I'm developing a PostgreSQL application for Windows CE 5 on a PDT/ PDA in C++/Qt, using Hiroshi Saito's libpq port for that platform. Since the connection is established over wi-fi, and wi-fi connectivity is often flaky, I feel that I have to

Re: [GENERAL] Connecting to a postgreSQL database with windows CE over wi-fi; failing gracefully

Wow, a response from the famous Tom Lane to my lame problem :-) . What I'd try is a ping to the database server, and not initiate any libpq operation unless the server is answering pings.  If you get a failure due to connectivity loss midway through an operation, PQreset is appropriate then

[GENERAL] Connecting to a postgreSQL database with windows CE over wi-fi; failing gracefully

Hello, I'm developing a PostgreSQL application for Windows CE 5 on a PDT/ PDA in C++/Qt, using Hiroshi Saito's libpq port for that platform. Since the connection is established over wi-fi, and wi-fi connectivity is often flaky, I feel that I have to fail gracefully to as great an extent as

Re: [GENERAL] connecting using libpq breaks printf

Joey Morris wrote: This is my first attempt at using libpq, and I'm running across a strange problem. Here is my bare-bones program: #include stdio.h #include libpq-fe.h int main(int argc, char **argv) { PGconn *conn; fprintf(stderr, connecting\n); conn =

[GENERAL] connecting using libpq breaks printf

This is my first attempt at using libpq, and I'm running across a strange problem. Here is my bare-bones program: #include stdio.h #include libpq-fe.h int main(int argc, char **argv) { PGconn *conn; fprintf(stderr, connecting\n); conn = PQconnectdb(dbname=postgres); PQfinish(conn);

[GENERAL] connecting using libpq breaks printf

This is my first attempt at using libpq, and I'm running across a strange problem. Here is my bare-bones program: #include stdio.h #include libpq-fe.h int main(int argc, char **argv) { PGconn *conn; fprintf(stderr, connecting\n); conn = PQconnectdb(dbname=postgres); PQfinish(conn);

Re: [GENERAL] connecting using libpq breaks printf

This is my first attempt at using libpq, and I'm running across a strange problem. Here is my bare-bones program: #include stdio.h #include libpq-fe.h int main(int argc, char **argv) { PGconn *conn; fprintf(stderr, connecting\n); conn = PQconnectdb(dbname=postgres);

Re: [GENERAL] connecting using libpq breaks printf

Hi, This is my first attempt at using libpq, and I'm running across a strange problem. Here is my bare-bones program: #includestdio.h #include libpq-fe.h int main(int argc, char **argv) { PGconn *conn; fprintf(stderr, connecting\n); conn = PQconnectdb(dbname=postgres);

Re: [GENERAL] connecting using libpq breaks printf

Lennin Caro lennin.c...@yahoo.com wrote on Wed, Feb 18, 2009 at 06:53:32AM -0800: try fprintf(stdout,Connection \n); printf(Connection \n); Thanks, but both produce the same behavior as fprintf(stderr, Connection \n): It prints when the PQconnectdb and PQfinish lines are commented out but

Re: [GENERAL] connecting using libpq breaks printf

Hi, Looks like you accidently wrote to me personnally, not to mailing list. On Wed, Feb 18, 2009 at 10:01 AM, Aurimas Černiusauri...@gmail.com wrote: Did you use *exactly* the same command line to compile both versions? What is that command line(s)? Yes, I used the same compilation command

Re: [GENERAL] connecting using libpq breaks printf

Aurimas Černius auri...@gmail.com wrote on Wed, Feb 18, 2009 at 06:08:07PM +0200: Libraries should be places after the source file, that is (not sure about -L, but for -l surely): gcc -o pq_test -IC:\Program Files\PostgreSQL\8.3\include pq_test.c -LC:\Program Files\PostgreSQL\8.3\lib

Re: [GENERAL] connecting using libpq breaks printf

Hi, Aurimas Černiusauri...@gmail.com wrote on Wed, Feb 18, 2009 at 06:08:07PM +0200: Libraries should be places after the source file, that is (not sure about -L, but for -l surely): gcc -o pq_test -IC:\Program Files\PostgreSQL\8.3\include pq_test.c -LC:\Program Files\PostgreSQL\8.3\lib

Re: [GENERAL] connecting using libpq breaks printf

On Wed, Feb 18, 2009 at 9:47 AM, Joey Morris rjmorri...@gmail.com wrote: I expected this program to print connecting, but in fact I get no output whatsoever. If I comment out the PQconnectdb and PQfinish lines, I see connecting as expected. What could be going on here? Try adding

Re: [GENERAL] connecting using libpq breaks printf

David Wilson david.t.wil...@gmail.com wrote on Wed, Feb 18, 2009 at 11:36:44AM -0500: Try adding fflush(stderr); after your fprintf() call. If the connection is hanging and output hasn't been flushed, you wouldn't see much. No, this doesn't help, either. Thanks for the suggestion. -- Sent

Re: [GENERAL] connecting using libpq breaks printf

On Wed, Feb 18, 2009 at 06:08:07PM +0200, Aurimas Cernius wrote: Joey Morris wrote: gcc -o pq_test -IC:\Program Files\PostgreSQL\8.3\include -LC:\Program Files\PostgreSQL\8.3\lib -lpq pq_test.c gcc won't give many warnings unless you give it a -Wall flag; it may be doing strange things and

Re: [GENERAL] connecting using libpq breaks printf

On Wed, Feb 18, 2009 at 4:47 PM, Joey Morris rjmorri...@gmail.com wrote: This is my first attempt at using libpq, and I'm running across a strange problem. Here is my bare-bones program: #include stdio.h #include libpq-fe.h int main(int argc, char **argv) { PGconn *conn;

Re: [GENERAL] connecting using libpq breaks printf

How do you run the program, in console or by double clicking on executable. Try the second. Does the console window apear on the screen? Aha! This tip has led to the solution. I had been running the program from an emacs shell buffer. If I run it from the Windows console or by double-clicking

Re: [GENERAL] connecting using libpq breaks printf

Aurimas Černius auri...@gmail.com wrote on Wed, Feb 18, 2009 at 05:01:14PM +0200: Did you use *exactly* the same command line to compile both versions? What is that command line(s)? Yes, I used the same compilation command line for both versions: gcc -o pq_test -IC:\Program

Re: [GENERAL] Connecting to old 7.1 Database

On Tue, Nov 18, 2008 at 18:34, Andy Greensted ajg...@ohm.york.ac.uk wrote: So, two questions: - Is there anyway to run a newer version (8.3.5) of psql in some sort of 'backwards compatible' mode? - Do you have any tips on making 7.1.3 compile on a newer system? The last time I had to

[GENERAL] Connecting to old 7.1 Database

Hi All, I need to connect to a version 7.1 PostgreSQL database. Unfortunately, I cannot get the 7.1.3 source to compile. configure gives this error: checking types of arguments for accept()... configure: error: could not determine argument types I'm not posting to pgsql-bugs because I

Re: [GENERAL] Connecting to old 7.1 Database

After a trying a few different versions, 7.2.8 seems to compile OK and is happy connecting to a 7.1 server. Andy Andy Greensted wrote: Hi All, I need to connect to a version 7.1 PostgreSQL database. Unfortunately, I cannot get the 7.1.3 source to compile. configure gives this error:

Re: [GENERAL] Connecting to old 7.1 Database

On 19/11/2008 10:57, Andy Greensted wrote: - Is there anyway to run a newer version (8.3.5) of psql in some sort of 'backwards compatible' mode? Newer versions of pg_dump are usually able to dump data from older PG versions, so in theory you ought to be able to suck your data from the old DB

[GENERAL] Connecting to old 7.1 Database

Hi All, I need to connect to a version 7.1 PostgreSQL database. Unfortunately, I cannot get the 7.1.3 source to compile. configure gives this error: checking types of arguments for accept()... configure: error: could not determine argument types I'm not posting to pgsql-bugs because I think

[GENERAL] Connecting to an existing transaction state.

Hello, I’m in the process of creating a set of scripts for testing certain locking features in an application. What I would like to do: 1. Start a connection from machine-01 through the m01-s1.sql script. 2.While (1) is running, start another transaction on the same database from machine-02

Re: [GENERAL] Connecting to an existing transaction state.

On 10:37 am 07/28/08 Alex Gen [EMAIL PROTECTED] wrote: 3. Using m01-s2.sql I would like to execute a certain SQL statement – BUT within the scope of the transaction begun by m01-s1.sql. I believe that is not possible. Specially if you are within a transaction on each of the scripts. As far as

Re: [GENERAL] Connecting to an existing transaction state.

Alex Gen wrote: Hello, I’m in the process of creating a set of scripts for testing certain locking features in an application. What I would like to do: 1. Start a connection from machine-01 through the m01-s1.sql script. 2.While (1) is running, start another transaction on the same

Re: [GENERAL] Connecting to an existing transaction state.

Alvaro Herrera wrote: Alex Gen wrote: Hello, I’m in the process of creating a set of scripts for testing certain locking features in an application. What I would like to do: 1. Start a connection from machine-01 through the m01-s1.sql script. 2.While (1) is running, start another

[GENERAL] Connecting to an existing transaction state.

Hello, I’m in the process of creating a set of scripts for testing certain locking features in an application. What I would like to do: 1. Start a connection from machine-01 through the m01-s1.sql script. 2.While (1) is running, start another transaction on the same database from machine-02

Re: [GENERAL] connecting VB to postgreSQL

In any case, it's obvious in your screenshot that you left the server and location fields blank in the connection setup form. This is most likely the cause of your problem. *doesnt work either..OLE-DB error persists. thanks for the readmefile. * On Wed, Apr 9, 2008 at 8:04 PM, Craig Ringer [EMAIL

[GENERAL] connecting VB to postgreSQL

Hello, I wish to connect Visual Studio 2008(VB) to PostgreSQL.. I used the following help file to do it .. http://support.microsoft.com/?scid=kb%3Ben-us%3B316649x=12y=14 Unfortunately, it does not connect..although when you test connection, using test connection switch, VB displays test

Re: [GENERAL] connecting VB to postgreSQL

Hi Richard, is it possible to check them individually how ? well..!! I think it has something to do with settings. couldnt even add a connection because once i click ok, it show the OLE-DB error, so no question about executing statements.. In tried with mdb database it works. Found some

Re: [GENERAL] connecting VB to postgreSQL

leoabhi wrote: The error in English means Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Well, did you check each OLE DB status value? Which failed and what was it doing? Are there any errors logged at the server? Did you turn

Re: [GENERAL] connecting VB to postgreSQL

leoabhi wrote: Hi Richard, is it possible to check them individually how ? No idea - you're one using .net - how would you normally check? well..!! I think it has something to do with settings. couldnt even add a connection because once i click ok, it show the OLE-DB error, so no

Re: [GENERAL] connecting VB to postgreSQL

Hello, In brief. TASK : Write a code in VB so that i can connect to postgreSQL and then execute some stataments from my VB application. I didnt want to code it ..I found the other way round very similar but without coding. Visual basic has a server explorer .. which can be used to connect to

Re: [GENERAL] connecting VB to postgreSQL

leoabhi wrote: now my first 2 posts speak about this setup and problem/error i had while setting up connection..it gives OLE-DB error which we already spoke about..STILL UNRESOLVED. All goes around setup required to connect to postgreSQL using VB ,Server Explorer. I need the settings to be

Re: [GENERAL] connecting VB to postgreSQL

Did 30 seconds search worked ? for me its didnt ? Please just dont test the connection, the applet shows Connection successful , Are you able to create it and see it under Server Explorer? Abhi On Wed, Apr 9, 2008 at 7:39 PM, Craig Ringer [EMAIL PROTECTED] wrote: leoabhi wrote: now my

Re: [GENERAL] connecting VB to postgreSQL

Abhishek MANDHANA wrote: Did 30 seconds search worked ? for me its didnt ? Please just dont test the connection, the applet shows Connection successful , Are you able to create it and see it under Server Explorer? I mostly use Linux. I'm on Vista right now, but I have never used Visual

Re: [GENERAL] connecting VB to postgreSQL

On Wed, Apr 9, 2008 at 7:20 AM, leoabhi [EMAIL PROTECTED] wrote: Hello, Hello Abhi! I wish to connect Visual Studio 2008(VB) to PostgreSQL.. Have you tried Npgsql? http://www.npgsql.org http://project.npgsql.org http://documentation.npgsql.org I hope it helps. -- Regards,

Re: [GENERAL] Connecting to PostgreSQL server with Mono using ident authetication

Andreas Tille wrote: On Wed, 5 Sep 2007, Andreas Tille wrote: On Mon, 4 Sep 2007, Albe Laurenz wrote: The best list for this kind of thing is certainly the Npgsql mailing list: http://gborg.postgresql.org/mailman/listinfo/npgsql-general Just subscribed. Well, I looked at the archives of

Re: [GENERAL] Connecting to PostgreSQL server with Mono using ident authetication

On Wed, 5 Sep 2007, Andreas Tille wrote: On Mon, 4 Sep 2007, Albe Laurenz wrote: The best list for this kind of thing is certainly the Npgsql mailing list: http://gborg.postgresql.org/mailman/listinfo/npgsql-general Just subscribed. Well, I looked at the archives of this list and also at

Re: [GENERAL] Connecting to PostgreSQL server with Mono using ident authetication

it is my first shot using Mono and I failed to get the example from http://www.mono-project.de/wiki/keyword/PostgreSQL/ working. The reason is obviousely that whatever I tried NpgsqlConnection tries to use password authentication but I have configured my system that ident

Re: [GENERAL] Connecting to PostgreSQL server with Mono using ident authetication

On Mon, 4 Sep 2007, Albe Laurenz wrote: The best list for this kind of thing is certainly the Npgsql mailing list: http://gborg.postgresql.org/mailman/listinfo/npgsql-general Just subscribed. What error messages do you get when you try to connect? When I use the connection string

[GENERAL] Connecting to PostgreSQL server with Mono using ident authetication

Hi, it is my first shot using Mono and I failed to get the example from http://www.mono-project.de/wiki/keyword/PostgreSQL/ working. The reason is obviousely that whatever I tried NpgsqlConnection tries to use password authentication but I have configured my system that ident

[GENERAL] Connecting from one computer to another over lan

I've installed postgresql 8.2 on a windows vista machine and are trying to connect to it from another one. the server has ip 192.168.1.100 and the client 192.168.1.102 As I understand it, I should make some configuration changes in pg_hba.conf to make this happen. Both machines has both ipv4 and

[GENERAL] Connecting a sequence with table column

I am using PGSQL 8.2.3 on Windows XP and pgAdmin 1.6.3. While adding columns to a table from pgAdmin front-end, an option appears sequence with a drop-down box on the column creation window, but it remains disabled. I have already created a sequence but want to connect that sequence with this

Re: [GENERAL] Connecting a sequence with table column

RPK wrote: I am using PGSQL 8.2.3 on Windows XP and pgAdmin 1.6.3. While adding columns to a table from pgAdmin front-end, an option appears sequence with a drop-down box on the column creation window, but it remains disabled. I have already created a sequence but want to connect that sequence

[GENERAL] Connecting to a remote server, pg_hba.conf error?

I am trying to connect to a postgres 8.1 installation on a ubuntu box from windows xp. I get this error: FATAL: missing or erroneous pg_hba.conf file HINT see server log for details. The server ip address is 192.168.1.10. The workstation ip address is 192.168.2.100. The server firewall allows

Re: [GENERAL] Connecting to a remote server, pg_hba.conf error?

novnov [EMAIL PROTECTED] writes: I am trying to connect to a postgres 8.1 installation on a ubuntu box from windows xp. I get this error: FATAL: missing or erroneous pg_hba.conf file HINT see server log for details. The server ip address is 192.168.1.10. The workstation ip address is

Re: [GENERAL] Connecting to a remote server, pg_hba.conf error?

Wonderful, that solved it...THANK YOU! Douglas McNaught wrote: novnov [EMAIL PROTECTED] writes: I am trying to connect to a postgres 8.1 installation on a ubuntu box from windows xp. I get this error: FATAL: missing or erroneous pg_hba.conf file HINT see server log for details. The

[GENERAL] Connecting performance

Dear : These days, I come across a problem that I can’t solve i , so I ask U for help. Problem Description: I use RedHat AS 4 + PostgreSQL 8.1 as our server. As long as the server program starts, it’ll immediately open 10~20 connects to the DB to handle

Re: [GENERAL] Connecting performance

Sounds like pgpool. http://pgpool.projects.postgresql.org/ On Thu, 2006-12-21 at 12:01 +0800, 马庆 wrote: Dear : These days, I come across a problem that I can’t solve i , so I ask U for help. Problem Description: I use RedHat AS 4 + PostgreSQL 8.1 as

Re: [GENERAL] Connecting via ssh tunnel

Hi all! [EMAIL PROTECTED] wrote: On Friday 24 November 2006 12:56, ben short wrote: I have a postgresql server setup on a Solaris 10 box. I can connect to the db via psql from the local machine. What I have been trying to do it connect with pgAdmin from my workstation. I have setup the

Re: [GENERAL] Connecting via ssh tunnel

Ok I have fixed it. My port fowarding was fine but i needed to set AllowTcpForwarding to yes in sshd_config. Ben On 11/27/06, Weerts, Jan [EMAIL PROTECTED] wrote: Hi all! [EMAIL PROTECTED] wrote: On Friday 24 November 2006 12:56, ben short wrote: I have a postgresql server setup on a

Re: [GENERAL] Connecting via ssh tunnel

On Monday 27 November 2006 02:38, Weerts, Jan wrote: Hi all! [EMAIL PROTECTED] wrote: On Friday 24 November 2006 12:56, ben short wrote: I have a postgresql server setup on a Solaris 10 box. I can connect to the db via psql from the local machine. What I have been trying to do it

Re: [GENERAL] Connecting via ssh tunnel

On Nov 24, 2006, at 2:56 PM, ben short wrote: I have a postgresql server setup on a Solaris 10 box. I can connect to the db via psql from the local machine. What I have been trying to do it connect with pgAdmin from my workstation. I have setup the tunnel correctly, local port 5432 and

[GENERAL] Connecting via ssh tunnel

Hi, I have a postgresql server setup on a Solaris 10 box. I can connect to the db via psql from the local machine. What I have been trying to do it connect with pgAdmin from my workstation. I have setup the tunnel correctly, local port 5432 and destination localhost:5432. Everytime I try to

Re: [GENERAL] Connecting via ssh tunnel

Hi, I have a postgresql server setup on a Solaris 10 box. I can connect to the db via psql from the local machine. What I have been trying to do it connect with pgAdmin from my workstation. I have setup the tunnel correctly, local port 5432 and destination localhost:5432. Everytime I try to

Re: [GENERAL] Connecting via ssh tunnel

ben short [EMAIL PROTECTED] writes: I have a postgresql server setup on a Solaris 10 box. I can connect to the db via psql from the local machine. What I have been trying to do it connect with pgAdmin from my workstation. I have setup the tunnel correctly, local port 5432 and destination

Re: [GENERAL] Connecting via ssh tunnel

On Friday 24 November 2006 12:56, ben short wrote: Hi, I have a postgresql server setup on a Solaris 10 box. I can connect to the db via psql from the local machine. What I have been trying to do it connect with pgAdmin from my workstation. I have setup the tunnel correctly, local port 5432

Re: [GENERAL] Connecting via ssh tunnel

On Fri, Nov 24, 2006 at 04:42:56PM -0500, Tom Lane wrote: Surely that is not a correct tunnel setup ... you can't have both ends being the same port number on the same machine. There Can Be Only One process listening on a given port per machine. I think he is refering the -L option of ssh

[GENERAL] Connecting to another postgres DB from pg/SQL

During execution of PL/pgSQL procedure I have to send somehow few date to another Postgress database. Is to possible to connect to other database , if yes what is performance of such solution? Is it possible to create DB link between two Postgres application? Michał Szymański

Re: [GENERAL] Connecting to another postgres DB from pg/SQL

You can use the dblink ( http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/) contrib module for that purpose. Thanks, Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 11/22/06, Szymanski, Michal (GE Money) [EMAIL PROTECTED] wrote: During execution of PL/pgSQL

[GENERAL] Connecting to PostgreSQL Server

Hello, I installed a postgresql server on one of the machine in my network with an example IP 192.168.254.102. I have no problem to connect to the server from this machine, but when I want to have access to pgsql server from other pc with an example IP 192.168.254.105 it says that I have no

Re: [GENERAL] Connecting to PostgreSQL Server

I am brazilian and have write dificility ,but code pg_hba is: host all all 192.168.254.105/32 md5 and after reload configuration. Belê! ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [GENERAL] Connecting to PostgreSQL Server

On 21/9/2006 18:36, Lukasz [EMAIL PROTECTED] wrote: Hello, I installed a postgresql server on one of the machine in my network with an example IP 192.168.254.102. I have no problem to connect to the server from this machine, but when I want to have access to pgsql server from other pc with

[GENERAL] Connecting to PostgreSQL on Linux with windows

Hi, I have a linux box (Fedora 3) running the latest version of PostgreSQL and PostGIS. I am trying connect to the database through a windows computer but can't seem to make the connection work. I've configured the pb_hba.config file in the usr directory to as host all all

Re: [GENERAL] Connecting to PostgreSQL on Linux with windows

On 10 May 2006 07:46:01 -0700, mmaclennan [EMAIL PROTECTED] wrote: Hi, I have a linux box (Fedora 3) running the latest version of PostgreSQL and PostGIS. I am trying connect to the database through a windows computer but can't seem to make the connection work. I've configured the pb_hba.config

Re: [GENERAL] Connecting to PostgreSQL on Linux with windows

mmaclennan [EMAIL PROTECTED] writes: Hi, I have a linux box (Fedora 3) running the latest version of PostgreSQL and PostGIS. I am trying connect to the database through a windows computer but can't seem to make the connection work. I've configured the pb_hba.config file in the usr directory to

  1   2   >