I need to retrieve my asterisk to retrieve a values from postgresql, i am looking for some sort of application like *mysql*() app, I found one but it is only available on Suse, is there any way for doing this? Regards, O.Youssef -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20070104/e5a16685/attachment.htm
O.Kamal wrote:> I need to retrieve my asterisk to retrieve a values from postgresql, i > am looking for some sort of application like *mysql*() app, I found one > but it is only available on Suse, is there any way for doing this? > > Regards, > O.Youssef >What do you need to do? To get an SQL console with postgres you need to: psql -d <database name to start in> -U <username to connect as> ie: psql -d asterisk -U asterisk The location of psql is different depensing upon distribution but usually it's in either /usr/bin/psql or /usr/local/pgsql/bin/psql. I'm not sure if this is what you want, if you want a pretty GUI front-end then you could look at Pgadmin III (www.pgadmin.org) which will run on Windows 2000/XP/2003 or unix/linux running X and requires wxWindows and a pile of common libraries.
Is that procedure the way to completely switch Asterisk from dependency on MySQL to dependency on Postgres instead? How about with Asterisk 1.4? And anyone have any idea whether FreePBX can be switched from MySQL to Postgres, too? On Tue, 2007-01-09 at 16:01 -0700, asterisk-users-request@lists.digium.com wrote:> Date: Tue, 9 Jan 2007 16:54:24 -0400 > From: "Humberto Figuera" <hfiguera@gmail.com> > Subject: Re: [asterisk-users] postgres and asterisk > To: "Asterisk Users Mailing List - Non-Commercial Discussion" > <asterisk-users@lists.digium.com> > Message-ID: > <9016d58c0701091254v12929042g184e34f1b2d56147@mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Hi O.Youssef, > > if you asterisk version is 1.2.X > > edit apps/Makefile > > and discomment the line that contain 'app_sql_postgres.so': > > # > # Obsolete things... > # > APPS+=app_sql_postgres.so > #APPS+=app_sql_odbc.so > > save > > if you use debian: > > aptitude install libpq-dev > > and compile again > > I hope this be helpfull ;p > > -- > Humberto Figuera - Using Linux 2.6.18 > Usuario GNU/Linux 369709 > Caracas - Venezuela > GPG Key Fingerprint = 5AAC DF0C 00F4 2834 28BA 37AD 3364 01D1 74CA > 0603 > >-- (C) Matthew Rubenstein