[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 structur

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 read > > access. > > > > I need to creat

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 t

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 from a table in > MS

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 g

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 Postg

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 Post

[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 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 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 "Peer authentication is only available on oper

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 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 signal. If you e

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 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: >> >> > > wou

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 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 just needed to:

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 SYSTEM-USERNAME

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; creat

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 wrote: > Hello, > > I want to connect to my local installation of PostgreSQ

[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

[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 program

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* odbcad

[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 the

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 ot

[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 the

Re: [GENERAL] Connecting matlab with postgresql

Sukuchha Shrestha 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 into a csv wh

[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 databas

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 tryi

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 exa

[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 DBD::Ter

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

On 2009-06-18, David Shen 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 is "no password

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

--- On Thu, 6/18/09, David Shen wrote: > From: David Shen > 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 to connect to my po

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 making

[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 c

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 t

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

Peter Geoghegan 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 "fail gracefully" to as

[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 possi

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 > #include "libpq-fe.h" > > int main(int argc, char **argv) { > PGconn *conn; > fprintf(stderr, "connecting\n"); > conn = PQconnectdb("dbnam

[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 #include "libpq-fe.h" int main(int argc, char **argv) { PGconn *conn; fprintf(stderr, "connecting\n"); conn = PQconnectdb("dbname=postgres"); PQfinish(conn); retur

Re: [GENERAL] connecting using libpq breaks printf

Aurimas Černius 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 -I"C:\Program Files\PostgreSQL\8.3\include" -L"

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-clickin

Re: [GENERAL] connecting using libpq breaks printf

On Wed, Feb 18, 2009 at 4:47 PM, 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 > #include "libpq-fe.h" > > int main(int argc, char **argv) { > PGconn *conn; > fprintf(stderr, "connecting\n")

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 -I"C:\Program Files\PostgreSQL\8.3\include" -L"C:\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 thi

Re: [GENERAL] connecting using libpq breaks printf

David Wilson 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 via pgsql-general mai

Re: [GENERAL] connecting using libpq breaks printf

On Wed, Feb 18, 2009 at 9:47 AM, Joey Morris 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 "fflush(stderr);" after yo

Re: [GENERAL] connecting using libpq breaks printf

Hi, Aurimas Černius 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 -I"C:\Program Files\PostgreSQL\8.3\include" pq_test.c -L"C:\Program Files\PostgreSQL\8.3\lib" -lpq I don't if

Re: [GENERAL] connecting using libpq breaks printf

Aurimas Černius 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 -I"C:\Program Files\PostgreSQL\8.3\include" pq_test.c > -L"C:\Program Files\PostgreSQL\8.3\lib" -lpq > > I d

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 Černius 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 line for both ver

Re: [GENERAL] connecting using libpq breaks printf

Lennin Caro 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 not when they a

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: #include #include "libpq-fe.h" int main(int argc, char **argv) { PGconn *conn; fprintf(stderr, "connecting\n"); conn = PQconnectdb("dbname=postgres"); PQfinish(con

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 > #include "libpq-fe.h" > > int main(int argc, char **argv) { > PGconn *conn; > fprintf(stderr, "connecting\n"); > conn = PQconnectdb("dbname=postgres"); >

[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 #include "libpq-fe.h" int main(int argc, char **argv) { PGconn *conn; fprintf(stderr, "connecting\n"); conn = PQconnectdb("dbname=postgres"); PQfinish(conn); retur

Re: [GENERAL] Connecting to old 7.1 Database

On Tue, Nov 18, 2008 at 18:34, Andy Greensted 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 compile super old cod

[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

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: checking

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 thi

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 an

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.

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

[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 usin

[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 usin

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 <[E

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, Fr

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 Ba

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 m

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 done

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 v

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 quest

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 more

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 t

[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%3B316649&x=12&y=14 Unfortunately, it does not connect..although when you test connection, using test connection switch, VB displays test con

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 t

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

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 string

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 au

[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 authentication

[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

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 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 co

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 d

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 >

[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 con

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

[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 th

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 destinatio

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

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 S

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 t

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 s

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

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 destinatio

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 >

[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 conne

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 procedu

[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 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 othe

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? http://www.p

[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 a

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 direc

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

[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 192.168.

  1   2   >