I adjusted it for my database and gives me error EFATAL: no pg_hba.conf entry for host "", user "", database "", SSL off
any way to resolved this ? On Tue, Apr 18, 2017 at 1:24 AM Benoit St-Jean <bstj...@yahoo.com> wrote: > Try this: > > | sql conn connectionSpec result | > sql := 'SELECT * FROM search_terms'. > conn := GAConnection new. > connectionSpec := GAConnectionArgs > hostname: 'localhost' > portno: 5432 > databaseName: 'sodbxtest' > userName: 'sodbxtest' > password: 'sodbxtest'. > conn connectionArgs: connectionSpec. > > "Connect to the server" > result := conn startup. > (result errorResponse isKindOf: GAErrorResponse) ifTrue: [ self halt ]. > > "Execute your SQL stuff" > result := conn execute: sql. > (result errorResponse isKindOf: GAErrorResponse) ifTrue: [ self halt ] > ifFalse: [result inspect]. > > "Disconnect from the server" > conn close. > > > ----------------- > Benoît St-Jean > Yahoo! Messenger: bstjean > Twitter: @BenLeChialeux > Pinterest: benoitstjean > Instagram: Chef_Benito > IRC: lamneth > Blogue: endormitoire.wordpress.com > "A standpoint is an intellectual horizon of radius zero". (A. Einstein) > > > ------------------------------ > *From:* Dimitris Chloupis <kilon.al...@gmail.com> > *To:* Benoit St-Jean <bstj...@yahoo.com>; Any question about pharo is > welcome <pharo-users@lists.pharo.org> > *Sent:* Monday, April 17, 2017 5:24 PM > > *Subject:* Re: [Pharo-users] PostgreSQL and Pharo 6 > > Following the instructions here > > http://guillep.github.io/DBXTalk/garage/installation.html > > I did > > Gofer it > smalltalkhubUser: 'DBXTalk' project: 'Garage'; > configurationOf: 'Garage'; > load. > > > (ConfigurationOfGarage project version: '0.5') > load: 'postgresV2'. > > And it did install > > > On Tue, 18 Apr 2017 at 00:02, Benoit St-Jean <bstj...@yahoo.com> wrote: > > Tell me which exact package you loaded (or even better, the exact to load > it) and I will test some code against my PostgreSQL server... > > > ----------------- > Benoît St-Jean > Yahoo! Messenger: bstjean > Twitter: @BenLeChialeux > Pinterest: benoitstjean > Instagram: Chef_Benito > IRC: lamneth > Blogue: endormitoire.wordpress.com > "A standpoint is an intellectual horizon of radius zero". (A. Einstein) > > > ------------------------------ > *From:* Dimitris Chloupis <kilon.al...@gmail.com> > *To:* Benoit St-Jean <bstj...@yahoo.com>; Any question about pharo is > welcome <pharo-users@lists.pharo.org> > *Sent:* Monday, April 17, 2017 4:55 PM > > *Subject:* Re: [Pharo-users] PostgreSQL and Pharo 6 > > no conn connect does not work because GAConnection has no such method. > #connect exist in GAPostgresDrive but even if I go that route I get error > #OptionAt:IfAbsent: was sent to nil . With this code > > conn2 := GAPostgresDriver new . > conn2 host: 'ec2-**-***-***-185.eu-west-1.compute.amazonaws.com' > port: '****' > database:'*******' > user: '*****' > password:''***'. > conn2 connect. > > Is there sample code that connects to online databases ? > > > > On Mon, Apr 17, 2017 at 11:18 PM Benoit St-Jean <bstj...@yahoo.com> wrote: > > You have to #connect before executing SQL statements! > > Something like (in your code): > > conn connect. > > ----------------- > Benoît St-Jean > Yahoo! Messenger: bstjean > Twitter: @BenLeChialeux > Pinterest: benoitstjean > Instagram: Chef_Benito > IRC: lamneth > Blogue: endormitoire.wordpress.com > "A standpoint is an intellectual horizon of radius zero". (A. Einstein) > > > ------------------------------ > *From:* Dimitris Chloupis <kilon.al...@gmail.com> > *To:* Benoit St-Jean <bstj...@yahoo.com>; Any question about pharo is > welcome <pharo-users@lists.pharo.org> > *Sent:* Monday, April 17, 2017 3:54 PM > *Subject:* Re: [Pharo-users] PostgreSQL and Pharo 6 > > Installing from Catalog Browser fails > > I installed it via the the website instructions, it installs fine > > But if I use it this way > > conn := GAConnection new. > ca := GAConnectionArgs hostname: 'ec2-**-***-***- > 185.eu-west-1.compute.amazonaws.com' > portno: '****' > databaseName:'*******' > userName: '*****' > password:''***'. > conn connectionArgs: ca. > conn execute: 'select * from search_terms'. > > it fails with no connection, is there anything else i need to do ? > is there a guide for how to use this ? > > > > On Mon, Apr 17, 2017 at 7:30 PM Dimitris Chloupis <kilon.al...@gmail.com> > wrote: > > thank you Benoit > > On Mon, Apr 17, 2017 at 4:23 AM Benoit St-Jean via Pharo-users < > pharo-users@lists.pharo.org> wrote: > > ODBC worked fine as well if you don't need native driver access > > ----------------- > Benoît St-Jean > Yahoo! Messenger: bstjean > Twitter: @BenLeChialeux > Pinterest: benoitstjean > Instagram: Chef_Benito > IRC: lamneth > Blogue: endormitoire.wordpress.com > "A standpoint is an intellectual horizon of radius zero". (A. Einstein) > > > ------------------------------ > *From:* Dimitris Chloupis <kilon.al...@gmail.com> > *To:* Any question about pharo is welcome <pharo-users@lists.pharo.org> > *Sent:* Sunday, April 16, 2017 4:37 AM > *Subject:* [Pharo-users] PostgreSQL and Pharo 6 > > Hey guys , I play with PostgreSQL and I really like it, sorry Esteban :D > > I am using Python for it but I would like to give access also to Pharo to > my database. I was informed that Garage has a driver for PostgreSQL , is > there any other candidate ? Any advice ? > > > > > > > > >
