Re: [GENERAL] Setting up replication slave on remote high latency host

Thank you for that. Back to the drawing board! On Wed, Nov 15, 2017 at 9:30 PM, John R Pierce wrote: > On 11/15/2017 6:02 PM, Rory Falloon wrote: > >> >> Right now I am trying to dump the database, gzip, move across, and import >> into the new slave (which is configured as a master to perform th

Re: [GENERAL] Setting up replication slave on remote high latency host

On 11/15/2017 6:02 PM, Rory Falloon wrote: Right now I am trying to dump the database, gzip, move across, and import into the new slave (which is configured as a master to perform the initial setup). Ideally I do this dump, move and import during a period of inactivity on the master so the ne

Re: [GENERAL] Setting up HA postgresql

Thanks so much for lending your expertise Tatsuo. Aviel I have found and linked below the relevant section of the official pgpool-II docs on using pgpool-II for failover. It is available starting in pgpool-II version 3.1: http://www.pgpool.net/docs/latest/pgpool-en.html#stream *Will J. Dunn* On

Re: [GENERAL] Setting up HA postgresql

On 07/21/2015 07:07 PM, Tatsuo Ishii wrote: But it appears that the fail condition for "watchdog" is the failure of a pgpool-II instance. In the configuration described in the wiki you would put a pgpool-II instance on each Postgres node, and if one of the pgpool-II instances fails it executes

Re: [GENERAL] Setting up HA postgresql

> But it appears that the fail condition for "watchdog" is the failure of a > pgpool-II instance. In the configuration described in the wiki you would > put a pgpool-II instance on each Postgres node, and if one of the pgpool-II > instances fails it executes a script (which can create the trigger f

Re: [GENERAL] Setting up HA postgresql

On 07/21/2015 02:48 PM, William Dunn wrote: Maybe Linux-HA which you recommended is the more promising option for open source tool. http://www.linux-ha.org/wiki/Main_Page The Postgres resource agent appears to monitor the instance by executing 'SELECT now();' which is typically the recommended

Re: [GENERAL] Setting up HA postgresql

Maybe Linux-HA which you recommended is the more promising option for open source tool. http://www.linux-ha.org/wiki/Main_Page The Postgres resource agent appears to monitor the instance by executing 'SELECT now();' which is typically the recommended check. Though, I do not know Linux-HA well enou

Re: [GENERAL] Setting up HA postgresql

On Tue, Jul 21, 2015 at 5:12 PM, Joshua D. Drake wrote: > > > "When backend node status changes by failover etc., watchdog notifies the > information to other pgpool-IIs and synchronizes them. When online recovery > occurs, watchdog restricts client connections to other pgpool-IIs for > avoiding

Re: [GENERAL] Setting up HA postgresql

On 07/21/2015 01:37 PM, William Dunn wrote: But it appears that the fail condition for "watchdog" is the failure of a pgpool-II instance. In the configuration described in the wiki you would put a pgpool-II instance on each Postgres node, and if one of the pgpool-II instances fails it executes a

Re: [GENERAL] Setting up HA postgresql

But it appears that the fail condition for "watchdog" is the failure of a pgpool-II instance. In the configuration described in the wiki you would put a pgpool-II instance on each Postgres node, and if one of the pgpool-II instances fails it executes a script (which can create the trigger file to p

Re: [GENERAL] Setting up HA postgresql

On 07/21/2015 01:21 PM, William Dunn wrote: That's pretty cool! But the intended use of watchdog is so you can have multiple pgpool-II instances and failover among them (http://www.pgpool.net/docs/latest/pgpool-en.html#watchdog) rather than failure of Postgres. In the configuration described in

Re: [GENERAL] Setting up HA postgresql

That's pretty cool! But the intended use of watchdog is so you can have multiple pgpool-II instances and failover among them ( http://www.pgpool.net/docs/latest/pgpool-en.html#watchdog) rather than failure of Postgres. In the configuration described in that wiki what happens when the DBMS goes down

Re: [GENERAL] Setting up HA postgresql

On 07/21/2015 11:04 AM, William Dunn wrote: If you dig deeper into pgpool-II you will find that it does not have failover logic. Its intention is to pool connections and distribute query load among replicas, but it cannot differentiate node failure from network partition and cannot promote a sta

Re: [GENERAL] Setting up HA postgresql

Implementing failover logic is quite simple, and probably even preferred over a pre-built solution because you can implement it in the way that integrates well with your architecture. The basic logic is as follows: - On the standby server you would configure the "trigger" file. When you cre

Re: [GENERAL] Setting up HA postgresql

If you dig deeper into pgpool-II you will find that it does not have failover logic. Its intention is to pool connections and distribute query load among replicas, but it cannot differentiate node failure from network partition and cannot promote a standby to master in the case of failure. *Will J

Re: [GENERAL] Setting up HA postgresql

Hi, I made the following document 4 years back: http://www.rummandba.com/2011/02/postgresql-failover-with-pgpool-ii.html You may have a look if it makes any good to your work. BTW, if you want to setup a share-nothing high scalable system with data-sharding, you can go for pl/proxy. Thanks. On

Re: [GENERAL] Setting up HA postgresql

Can you link me up to a good tutorial using pgpool-II? 2015-07-21 20:02 GMT+03:00 Joshua D. Drake : > > On 07/21/2015 08:34 AM, William Dunn wrote: > >> Hello Aviel, >> >> On Tue, Jul 21, 2015 at 3:56 AM, Aviel Buskila > > wrote: >> >> How can I set a highly availabl

Re: [GENERAL] Setting up HA postgresql

On 07/21/2015 08:34 AM, William Dunn wrote: Hello Aviel, On Tue, Jul 21, 2015 at 3:56 AM, Aviel Buskila mailto:avie...@gmail.com>> wrote: How can I set a highly available postgresql in a share-nothing architecture? I suggest you review the official documentation on high-availability c

Re: [GENERAL] Setting up HA postgresql

hey will, Is there any open-source tool instead of developing the fail-over logic by myself? 2015-07-21 18:34 GMT+03:00 William Dunn : > Hello Aviel, > > On Tue, Jul 21, 2015 at 3:56 AM, Aviel Buskila wrote: >> >> How can I set a highly available postgresql in a share-nothing >> architecture? >>

Re: [GENERAL] Setting up HA postgresql

Hello Aviel, On Tue, Jul 21, 2015 at 3:56 AM, Aviel Buskila wrote: > > How can I set a highly available postgresql in a share-nothing > architecture? > I suggest you review the official documentation on high-availability configurations linked below: http://www.postgresql.org/docs/current/static/

Re: [GENERAL] Setting up a database for 10000 concurrent users

sanjeetkamble wrote: > Please explain in details im not able to understand. https://wiki.postgresql.org/wiki/Number_Of_Database_Connections http://stackoverflow.com/questions/10419665/how-does-pgbouncer-help-to-speed-up-django/10420469#10420469 https://wiki.postgresql.org/wiki/PgBouncer -- Ke

Re: [GENERAL] Setting up a database for 10000 concurrent users

On 05/04/2015 11:11 PM, sanjeetkamble wrote: Hello, Please explain in details im not able to understand. You are going to have to be more specific. Do you want to know why setting max_connections=1 will not work? Do you want to know about connection pooling? Or do you want to know how t

Re: [GENERAL] Setting up a database for 10000 concurrent users

Hello, Please explain in details im not able to understand. -- View this message in context: http://postgresql.nabble.com/Setting-up-a-database-for-1-concurrent-users-tp1848801p5848004.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general

Re: [GENERAL] Setting up a database for 10000 concurrent users

On 05/04/2015 02:02 AM, sanjeetkamble wrote: Hello, Please let me know how The database server is started with max_connections = 1 ??? I have same issue, but i have a SAN storage where Postgresql is installed. Sanjeet On Mon, May 4, 2015 a

Re: [GENERAL] Setting up a database for 10000 concurrent users

I suggest pg_bouncer as opposed to pg_pool. My testing showed it handled connections better. Ultimately the choice is yours, but with 1 connections, you absolutely need a connection manger. On Mon, May 4, 2015 at 10:08 AM, Andy Colson wrote: > On 05/04/2015 02:02 AM, sanjeetkamble wrote: > >

Re: [GENERAL] Setting up a database for 10000 concurrent users

On 05/04/2015 02:02 AM, sanjeetkamble wrote: Hello, Please let me know how The database server is started with max_connections = 1 ??? I have same issue, but i have a SAN storage where Postgresql is installed. Sanjeet No doubt that would be a problem. Its bad idea. set max_connecti

Re: [GENERAL] Setting up a database for 10000 concurrent users

Hello, Please let me know how The database server is started with max_connections = 1 ??? I have same issue, but i have a SAN storage where Postgresql is installed. Sanjeet -- View this message in context: http://postgresql.nabble.com/Setting-up-a-database-for-1-concurrent-us

Re: [GENERAL] Setting up BDR 0.9.0 - error on bdr_group_create

On 26 March 2015 at 06:02, Steve Boyle wrote: > postgres=# SELECT bdr.bdr_group_create( > postgres(# local_node_name := 'cxtlabdev014', > postgres(# node_external_dsn := 'port=5432 dbname=prod' > postgres(# ); > ERROR: getting remote node id failed > DETAIL: SELECT sysid, timeline,

Re: [GENERAL] Setting up replication

On 03/17/2015 04:08 PM, Robert Fitzpatrick wrote: I have a question about setting up replication between my postgresql-9.3.6 servers. If I'm using pg_basebackup on my FreeBSD 10.1 slave server, the postgresql.conf file is in the data directory, which pg_basebackup insists must be empty. I can't f

Re: [GENERAL] Setting up tablepace

On 06/15/11 3:34 AM, Malm Paul wrote: Hi all, I have a problem with setting up tablespace on a ramdisk. the ramdisk shall be used temporary for storing unprotected map data, that is normaly protected. I'm working in Linux. I have an ordirnary Linux user called normaluser, a user called chartuse

Re: [GENERAL] setting up streaming error. Please help

akp geek writes: > *ldd libpqwalreceiver.so* > * libpq.so.4 =>/usr/lib/libpq.so.4* Looks like you need to recompile, for starters. libpq.so.4 would be 8.1 or even older. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To ma

Re: [GENERAL] setting up streaming error. Please help

Thanks Tom . When I did Is there any that I can run some commands to point it to *libpq.so.5. I have LD_LIBRARY_PATH =/opt/postgres/9.0.2/lib. still it is pointing to ** /usr/lib .. Any suggestions? * *ldd libpqwalreceiver.so* * libpq.so.4 =>/usr/lib/libpq.so.4* *libgcc_s.so

Re: [GENERAL] setting up streaming error. Please help

akp geek writes: > After making the required changes to the Primary and slave , I have > restarted the slave and I keep seeing the following in the logs. > *FATAL: could not connect to the primary server: invalid connection option > "replication"* That message has to be caused by libpq

Re: [GENERAL] setting up streaming error. Please help

Both the servers are having 9.0.2 Thanks On Fri, Jun 10, 2011 at 4:09 PM, Guillaume Lelarge wrote: > On Fri, 2011-06-10 at 15:46 -0400, akp geek wrote: > > Hi all - > > > > > > After making the required changes to the Primary and slave , > > I have restarted the slave and I keep seeing

Re: [GENERAL] setting up streaming error. Please help

On Fri, 2011-06-10 at 15:46 -0400, akp geek wrote: > Hi all - > > > After making the required changes to the Primary and slave , > I have restarted the slave and I keep seeing the following in the > logs. > > > Operating system is solaris. > > on the primar

Re: [GENERAL] Setting up pgpass.conf for the postgres OS user on windows for pgAgent

> pgpass.conf file should in %APPDATA%\postgresql directory of user/account, > which you will use to start the pgagent. > > Suppose if you want start pgagent as user peter account on windows, then you > have to keep the pgpass.conf file in %APPDATA%\postgresql directory of peter > account. > > -

Re: [GENERAL] Setting up pgpass.conf for the postgres OS user on windows for pgAgent

On Aug 12, 2010, at 2:43 PM, Peter Geoghegan wrote: > Hello, > > I would like to set up pgAgent on windows. I'm using the EDB 8.4.4 > package. I know that it is bad practice to put the password directly > in the conninfo string, so I've avoided that. I want to use pgpass > authentication, per th

Re: [GENERAL] Setting up phppgadmin under https/ssl (Apache)

I can't imagine you have to do much of anything to it. Once apache is set up to handle https:// requests, the rest should just happen. On Mon, May 19, 2008 at 12:33 AM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Wow...so does no one use phppgadmin on servers that they are connected > to via t

Re: [GENERAL] Setting up phppgadmin under https/ssl (Apache)

On Sun, 2008-05-18 at 23:33 -0700, [EMAIL PROTECTED] wrote: > Wow...so does no one use phppgadmin on servers that they are connected > to via the internet? Or if you do, how do you go about securing it so > that no one snoops your password? > > Thanks > > > On May 16, 12:34 am, "[EMAIL PROTECTE

Re: [GENERAL] Setting up phppgadmin under https/ssl (Apache)

Wow...so does no one use phppgadmin on servers that they are connected to via the internet? Or if you do, how do you go about securing it so that no one snoops your password? Thanks On May 16, 12:34 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Hi... > > This is as much an apache questio

Re: [GENERAL] Setting up phppgadmin under https/ssl (Apache)

[EMAIL PROTECTED] wrote: Hi... This is as much an apache question as anything else, but I think it's appropriate here. I've been using phppgadmin on my local machine. Now I've installed it on a remote server running Ubuntu lts 8.04. I figured I'd try and put it under ssl/https under Apache (m

Re: [GENERAL] Setting up functions in psql.

On Feb 16, 12:06 am, [EMAIL PROTECTED] (Paul Lambert) wrote: > Tom Lane wrote: > > Paul Lambert <[EMAIL PROTECTED]> writes: > >> What I am confused about is: Why does the creation of a function fail if > >> a table it uses does not exist when the function itself is creating the > >> table further u

Re: [GENERAL] Setting up functions in psql.

Tomas Vondra wrote: AutoDRS=# select "fnLoadAppraisals"(); ERROR: relation with OID 18072 does not exist CONTEXT: SQL function "fnLoadAppraisals" statement 5 18072 is the OID of table appraisals_temp_load If I run the code within the function by itself, i.e. copy and paste the 6 lines of

Re: [GENERAL] Setting up functions in psql.

AutoDRS=# select "fnLoadAppraisals"(); ERROR: relation with OID 18072 does not exist CONTEXT: SQL function "fnLoadAppraisals" statement 5 18072 is the OID of table appraisals_temp_load If I run the code within the function by itself, i.e. copy and paste the 6 lines of SQL int psql it runs

Re: [GENERAL] Setting up functions in psql.

2007/2/16, Paul Lambert <[EMAIL PROTECTED]>: In setting up some functions to load data from a csv file, I'm doing the following in psql on Weendoze: AutoDRS=# CREATE OR REPLACE FUNCTION "fnLoadAppraisals"() AutoDRS-# RETURNS void AS AutoDRS-# $BODY$ AutoDRS$# DROP TABLE IF EXISTS apprais

Re: [GENERAL] Setting up functions in psql.

Tom Lane wrote: Paul Lambert <[EMAIL PROTECTED]> writes: What I am confused about is: Why does the creation of a function fail if a table it uses does not exist when the function itself is creating the table further up to where it references it? Because the function isn't actually being *exec

Re: [GENERAL] Setting up functions in psql.

Paul Lambert <[EMAIL PROTECTED]> writes: > What I am confused about is: Why does the creation of a function fail if > a table it uses does not exist when the function itself is creating the > table further up to where it references it? Because the function isn't actually being *executed*, only s

Re: [GENERAL] Setting up a fine-grained permission system

IMHO, Veil is very strange project. Instead of concentrating on good support of updatable views, developers are trying to reinvent the wheel. Actually, if restriction-and-projection views would be updatable w/o overhead (such as creating rules), there'll no need in such project. It's one of the maj

Re: [GENERAL] Setting up a fine-grained permission system

Dave, Sorry to be so late in responding to this but I may have just the solution for you. Please check out Veil at pgfoundry. This is an add-on to Postgres that I think does just what you are looking for. As the developer of this project, I would be pleased to offer you assistance. http://veil.

Re: [GENERAL] Setting up a fine-grained permission system

Hi all. Implimenting a custom permission system is fairly easy to do with triggers, views, and rules. Here is my suggestion. Put your data tables in a shadow schema and don't give users access to them. Then create views that select the information from the tables that they have access to.

Re: [GENERAL] Setting up a fine-grained permission system

David Garamond <[EMAIL PROTECTED]> writes: > Hi, > > Our current project requires a fine-grained permission system (row-level > and possibly column-level as well). We have a pretty large (tens of > thousands) of users in the 'party' table. I'm thinking of choosing > Unix-style security for now (ad

Re: [GENERAL] Setting up a database for 10000 concurrent users

10GB of RAM isn't that farfetched nowadays. However I/O might be a problem. A single drive can typically write/read about 10MB a second (64KB chunks random access - not sure if you'd want to bet on getting sequential throughput ;) ). Anyway, it'll be something interesting to see ;). Link.

Re: [GENERAL] Setting up a database for 10000 concurrent users

At 09:45 PM 9/5/2005 +0100, Richard Huxton wrote: Poul Møller Hansen wrote: I'm trying to setup a database for 1 concurrent users for a test. I have a system with 1GB of RAM where I will use 512MB for PostgreSQL. It is running SuSE 9.3 I think you're being horribly optimistic if you actu

Re: [GENERAL] Setting up a database for 10000 concurrent users

"Sergey E. Koposov" <[EMAIL PROTECTED]> writes: > But I really doubt that it it possible/reasonable to have 1 > simultaneous connections. You're going to need a heck of a beefy machine to do it, anyway. I would expect that after fixing the semaphore configuration problem, the next thing that

Re: [GENERAL] Setting up a database for 10000 concurrent users

On Mon, 5 Sep 2005, [UTF-8] Poul Mц╦ller Hansen wrote: > I'm trying to setup a database for 1 concurrent users for a test. > I have a system with 1GB of RAM where I will use 512MB for PostgreSQL. > It is running SuSE 9.3 > > I have changed SHMMAX & SHMALL > echo "536870912" >/proc/sys/kernel/

Re: [GENERAL] Setting up a database for 10000 concurrent users

I think you're being horribly optimistic if you actually want 1 concurrent connections, with users all doing things. Even if you only allow 1MB for each connection that's 10GB of RAM you'd want. Plus a big chunk more to actually cache your database files and do work in. Then, if you had 1

Re: [GENERAL] Setting up a database for 10000 concurrent users

Poul Møller Hansen wrote: I'm trying to setup a database for 1 concurrent users for a test. I have a system with 1GB of RAM where I will use 512MB for PostgreSQL. It is running SuSE 9.3 I think you're being horribly optimistic if you actually want 1 concurrent connections, with users a

Re: [GENERAL] Setting up a database for 10000 concurrent users

Calculated the values should be SEMMNI = 1 / 16 SEMMNS = (1 / 16) * 17 "plus room for other applications" How much should that be ? And where can I change those values on a 2.6 kernel ? I will try to answer myself with another question. Can it be that it should be changed in /usr/src/

Re: [GENERAL] setting up

Thanks Roberto, I found a dev aritcle at apple explaining it... you have to create the dir... So ive done that and im all up and running. Thanks Eoghan On 23 Jul 2005, at 18:54, Ropel wrote: I don't know, OS x; on linux the local directory is /usr/local/ pgsql/data for 8.0 version, and used

Re: [GENERAL] setting up

I don't know, OS x; on linux the local directory is  /usr/local/pgsql/data for 8.0 version, and used to be /var/lib/pgsql/data on older versions for linux redhat. You should have the default superuser account postgres and the database template1 (don't change it, just login and create you own o

Re: [GENERAL] setting up PostgreSQL on Linux RHL9 to allow ODBC

cc: Subject: Re: [GENERAL] setting up PostgreSQL on Linux RHL9 to allow ODBC conne

Re: [GENERAL] setting up PostgreSQL on Linux RHL9 to allow ODBC connections from Windows

hi,  if the client machine is another linux ,  what is the correct way to configure ODBC thanks Hugo  Hi,All you need is the Windows ODBC driver, which you install on the client machine, and then configure it to talk to the Linux server onport 5432 (set by default).--Ray.>> Most of the documenta

Re: [GENERAL] setting up PostgreSQL on Linux RHL9 to allow ODBC connections

Not quite correct. TCP needs to be turned on AND an according entry in pg_hba.conf needs to be set up - otherwise the server will just decline to talk to the client. Also - if you're on XP you might want to check the "firewall" settings - which if configured wrong could potentially block connec

Re: [GENERAL] setting up PostgreSQL on Linux RHL9 to allow ODBC connections from Windows

On 22 Jun 2005 at 8:59, [EMAIL PROTECTED] wrote: > I have seen a bunch of different documentation on how to set up to > allow ODBC, but I am a little confused about how much/what has to be > set up to allow an ODBC connection from Windows (mostly 2003, some XP) > to an existing PostgreSQL (7.4.6)

Re: [GENERAL] setting up PostgreSQL on Linux RHL9 to allow ODBC connections

There's nothing on the server side that needs to be configured for Windows clients to access Postgres via ODBC. As long as TCP/IP is turned on. Just add a data source and configure the server ip/name/port/database/etc. [EMAIL PROTECTED] wrote: Hi, I have seen a bunch of different documenta

Re: [GENERAL] Setting up Postgresql on Linux

On 01/03/2004 23:22 Phil Campaigne wrote: Hello, I originally installed postgresql as root user and now I am setting up a development environment with cvs and a java ide and tomcat. I have everything with the exception of postgresql integreted using a non-root user. THe process I am using is to

Re: [GENERAL] Setting up Postgresql on Linux

On Thu, 4 Mar 2004, phil campaigne wrote: > Hello, > when I login to linux and check the env's I see: > PATH=/usr/local/pgsql/bin:/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin:/home/postgres/bin:/opt/IBMJava2-14/bin:/opt/IBMJava2-14/jre/bin:/usr/local/pgsql/bin > LD_LIBRARY_PATH=/usr/lo

Re: [GENERAL] Setting up Postgresql on Linux

Phil Campaigne wrote: Hi Ron, I had a couple of questions on your instructions: 1. what is this for? >#make install-all-headers According to the docs you need it if you are going to create your own functions, however the documentation is a bit *vague*. "If you plan to do any server-side program

Re: [GENERAL] Setting up Postgresql on Linux

Phil Campaigne wrote: Hello, I originally installed postgresql as root user and now I am setting up a development environment with cvs and a java ide and tomcat. I have everything with the exception of postgresql integreted using a non-root user. THe process I am using is to logon as postges a

Re: [GENERAL] Setting up Postgresql on Linux

On Mon, 1 Mar 2004, Phil Campaigne wrote: > Hello, > I originally installed postgresql as root user and now I am setting up a > development environment with cvs and a java ide and tomcat. I have > everything with the exception of postgresql integreted using a non-root > user. > THe process I am

Re: [GENERAL] Setting up DSPACE for Postgres access

> Given everything else you've tried, I think you might be on the right track > here and somehow your environment variables are getting clobbered. How or why > I couldn't say (I'd suspect Tomcat, but you say you can't even run the > create-administator app). Tomcat only uses the minor few and runs

Re: [GENERAL] Setting up DSPACE for Postgres access

Have you tried placing the jars in the $JAVA_HOME/jre/lib/ext directory? Jars there are automatically searched by the JVM. On Thursday, October 23, 2003, at 01:52 PM, Richard Huxton wrote: On Thursday 23 October 2003 18:07, Ashwin Kutty wrote: Now, the postgresql.jar gets pointed to twice; once

Re: [GENERAL] Setting up DSPACE for Postgres access

Agreed, however if its working fine on someone else's end then the problem is local to my environment. People do have difficulties setting up DSPACE but I currently have the front-end running fine. The dependencies are just crazy along with third party apps for DSPACE. However, all that is done

Re: [GENERAL] Setting up DSPACE for Postgres access

> Looking at the dspace docs (system prerequisites): > "Then when PostgreSQL has compiled, copy the new postgresql.jar to > dspace-1.1/lib." > > Strikes me as a bit strange it won't just use the classpath, but have you got > the jar in there too? Yes and in j2sdk's lib directory and in pgsql's sha

Re: [GENERAL] Setting up DSPACE for Postgres access

On Thursday 23 October 2003 15:52, Ashwin Kutty wrote: > > I thought and still under the impression that its looking in the classpath > for this and I have edited /etc/profile to include it, checked env before > running the program and it according to it the jar file is included fine > and the clas

Re: [GENERAL] Setting up DSPACE for Postgres access

Whenever I need to use the postgresql JDBC driver in my programs, I have to manually include the line: Class.forName("org.postgresql.Driver"); somewhere *before* I call DriverManager.getConnection. Try this in your test program and see if it works. Unfortunately, you may not be able to modify

Re: [GENERAL] Setting up DSPACE for Postgres access

> It's complaining that it cannot find a driver. The obvious steps are: > 1. Check you have your JDBC driver installed and configured. Yes. I have done so. Included in the Classpath env var as well. I have gone so far as to downloading it from jdbc.postgresql.org rather than using the compiled

Re: [GENERAL] Setting up DSPACE for Postgres access

On Thursday 23 October 2003 14:20, Ashwin Kutty wrote: > > I am currently testing a product by the name of dspace > (http://www.dspace.org) and require installing java since dspace is > completely java based. The problem is that during its installation it > needs to talk to pgsql via jdbc and I am