Hello I have a problem that has exhausted my ingenuity and would like pointers to a solution, or at least where to debug. - I am using R and postgresql. - I have databases on two different servers. - I have a few users, who use different client machines - whose R installations are identical (rsync'd)>From one client machine I can access databases on both servers, usingboth psql and by connecting using db.connect()>From another client I can access the databases on both servers usingpsql, BUT I cannot connect to the database on one of the servers using db.connect() It looks like an authentication/authorisation problem. There are no log entries anywhere that suggest auth/auth are failing - not in the postgres logs,not in the usual /var/log/* suspects. I'm using the same user/password for psql and db.connect(). Any suggestions? Thanks Brendan Murray
On 10 Feb 2003, Brendan Murray wrote:> I have a problem that has exhausted my ingenuity and would like pointers > to a solution, or at least where to debug. > > - I am using R and postgresql.And which R package are you using, which version, from which repository? -- Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, stats.ox.ac.uk/~ripley University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272860 (secr) Oxford OX1 3TG, UK Fax: +44 1865 272595