similar to: Authenticaing in postgresql

Hi all. I am using PostgreSQL in my current project and I have couple of questions on this topic. Previously I have used 3 databases for project. i.e. megaproject_development, megaproject_test and megaproject_development. But I don''t like this variant because of ''rake dump_db_structure'' writes a lot of PostgreSQL specific data for structure file (operators, functions,

ok, so I removed the default postgresql install and installed it from the software collections.. following the instructions at https://www.softwarecollections.org/en/scls/rhscl/rh-postgresql95/ and I get this [root at home1p /home/jason]$scl enable rh-postgresql95 bash [root at HOME1P jason]# postgresql-setup --initdb * Initializing database in

Hi, We are testing a SIP solution * + ser solution for a large implementation. All the clients are nated. When a client is dialing outside the domain (to a FWD sip account for example) all is perfect ! ;-) But ,when a call is done to a sip account, the client is ringing, then the caller can hear the nated client very well, but the nated client does'nt hear anything. RTP issue no ? I've

i have installed database POSTGRESQL for storing call details. when i restart database i get the error. [root at localhost server]# psql -h 127.0.0.1 -U asterisk Password psql: could not connect to server: Connection refused Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432? THIS IS MY /VAR/LIB/PGSQL/DATA/POSTGRESQL.CONF # CONNECTIONS AND

Hi, Using rake with Postgresql gives the following error: psql:db/development_structure.sql:13: ERROR: must be owner of schema public I''m using the latest version of rails and postgresql 8.0 on ruby 1.8.3 (2005-06-23) [i486-linux]. The above error occurs when rake clones my dev database to test - it first came to my attention when I ran "rake" for my first unit tests. It

On 11/3/2016 7:58 AM, Jason Welsh wrote: > ok, so I removed the default postgresql install and installed it from > the software collections.. > > following the instructions at > > https://www.softwarecollections.org/en/scls/rhscl/rh-postgresql95/ the best way to install postgresqol, imho, is from the yum.postgresql.com respoitory run by the postgresql development group. you

Hello I'm using dovecot with virtual accounts stored in a postgreSQL db. I use in the dovecot.conf: auth_userdb = pgsql /usr/local/etc/dovecot-pgsql-user.conf (and same for pass). In the file dovecot-pgsql-user.conf, I use: connect = host=127.0.0.1 dbname=vmail user=lecteur password=lire user_query = SELECT '/var/spool/vhosts/'||nom_domaine||'/'||nom_boite AS mail,5000 AS

I am pleased to announce the immediate availability of versions 9.2 and 9.4 of the PostgreSQL server on CentOS Linux 6 x86_64, delivered via a Software Collection (SCL) built by the SCLo Special Interest Group (https://wiki.centos.org/SpecialInterestGroup/SCLo). QuickStart ---------- You can get started in three easy steps (example of PostgreSQL 9.4): $ sudo yum install centos-release-scl

I am pleased to announce the immediate availability of versions 9.2 and 9.4 of the PostgreSQL server on CentOS Linux 7 x86_64, delivered via a Software Collection (SCL) built by the SCLo Special Interest Group (https://wiki.centos.org/SpecialInterestGroup/SCLo). QuickStart ---------- You can get started in three easy steps (example of PostgreSQL 9.4): $ sudo yum install centos-release-scl $

On Sat, 26 Aug 2017 18:35:31 -0700 Ira Sharenow via R-help <r-help at r-project.org> wrote: Can you access the postgres database through psql or some other route? Also, do you require a password to access the database from these alternatives? JWDougherty

Hello, I have tried to install the salted hash login generator by following the quick start guide at: http://wiki.rubyonrails.com/rails/pages/SaltedLoginGeneratorQuickstart. Everything seems to work fine until I try to run the unit tests by doing ''rake test_units'', then I get the following error message: <error-message> [brasse@keso login-test]$ rake test_units (in

http://dev.rubyonrails.org/ticket/1117 I''ve attached a patch to ticket 1117 which fixes it so that booleans are escaped as booleans, not integers. Specifically, this situation will now work find_all(["send_date=? and sent=?", Date.today, false]) Which matches peoples expectations, but it causes some problems with the postgresql unit tests. Specifically, the use of

I am currently facing the following log output: Apr 26 16:40:28 h2290750 dovecot: auth: Error: pgsql(localhost): Connect failed to database mail: could not connect to server: Permission denied Apr 26 16:40:28 h2290750 dovecot: auth: Error: #011Is the server running on host "localhost" (::1) and accepting Apr 26 16:40:28 h2290750 dovecot: auth: Error: #011TCP/IP connections on port 5432?

I have a shell script (sh) where I create a user and import data to a postgres database <snip> su -c "createuser -A -D -P $PG_user" postgres su -c "psql -d$PG_database -h localhost -U$PG_user -W -f postgresql.sql " postgres </snip> when the script executes those command, it ask for a password, how could I do this without have to enter the passwd, I would like that

Hi, I am having problem in configuring iptables for PostgreSQL server. I added following rule to iptables to allow connections to default PostgreSQL port (5432): {{{ sudo /sbin/iptables -A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp -s 10.0.0.0/24 --dport 5432 -j ACCEPT }}} After this I can't connect using telnet or psql (postgres client). Following error is received from telnet

Hi all, Hope somebody can help-I really am stumped as to why this won't work. I realise that this isnt an Asterisk problem (Please dont bash me on the list) and I have emailed the SER list but I havent received a reply and maybe someone on this list can help...Once this problem is solved I am going to use Asterisk for voicemail etc with SER (I have it set up) I currently have SER set up and

Hello there, Anyone have a Howto for me how i can configure dovecot to work with a PostgreSQL Database? (the docs are small), i want to use it with Exim4 and i have a error with SSL "imap-login: Can't load private key file /var/dovecot/ssl/private/imapd.pem: error:0906D06C:PEM routine:PEM_read_bio:no start line" i make my cert with this command (i don't like the included

Puppet 3.3.1 // CentOS release 6.4 (Final) rpm -qa | grep puppet puppetlabs-release-6-7.noarch puppet-3.1.1-1.el6.noarch puppetdb-1.3.0-1.el6.noarch puppet-server-3.1.1-1.el6.noarch puppetdb-terminus-1.3.0-1.el6.noarch Installed from yum packages: Running Transaction Installing : puppetdb-1.3.0-1.el6.noarch

On 11/2/2016 1:49 PM, Jason Welsh wrote: > on the old postgresql that comes with centos 6? > Ive asked google over and over and he wont tell me. :( > (im trying to install it as a requirement for NIPAP) I don't think Postgres 8.4 has the infrastructure that ip4r extension requires. but the ip4r release notes suggest... make NO_EXTENSION=1 make NO_EXTENSION=1 install

Hi all, I've got a nice shiny new server which I'm going to build as a LAPP platform. I've just had a quick look for suitable instructions on the best way to configure it and I have a few questions. There are many hits, some better than others. (It is replacing a Fedora 9 server so I'm expecting to have lots of *fun*) 1) 9.2 vs 9.5 Some of the instruction pages I've