Displaying 20 results from an estimated 10000 matches similar to: "Centos 7 LAPP setup Postgresql version and setup"
2018 Apr 05
1
Centos 7 LAPP setup PHP 5 vs 7
Another questions regarding my new server setup.
As with the Postgresql setup, different pages describing setting up a Centos
LAPP server have differing opinions about PHP versions.
The default distro's appear to still be installing PHP5 while some sites
instruct on how to install PHP7.
I am porting my old server which must be 10 years old, running Fedora 9 and
PHP5 onto the new server,
2016 Nov 03
0
how to install postgresql ip4r
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
2016 Nov 03
2
how to install postgresql ip4r
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
2015 Dec 21
0
Announcing release for PostgreSQL 9.2 and 9.4 on CentOS Linux 6 x86_64 SCL
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
2015 Dec 21
0
Announcing release for PostgreSQL 9.2 and 9.4 on CentOS Linux 7 x86_64 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
$
2005 Oct 28
3
PostgreSQL. Multiply schemas in one database. How to?
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,
2016 Jul 19
0
Announcing release of PostgreSQL 9.5 on CentOS Linux 6 x86_64 SCL
I am pleased to announce the immediate availability of version 9.5 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:
$ sudo yum install centos-release-scl
$ sudo yum install
2016 Jul 19
0
Announcing release of PostgreSQL 9.5 on CentOS Linux 7 x86_64 SCL
I am pleased to announce the immediate availability of version 9.5 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:
$ sudo yum install centos-release-scl
$ sudo yum install
2009 Nov 15
3
Database postgresql not able to start
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
2005 Sep 17
0
Postgresql + rake errors
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
2005 Sep 22
0
problem with postgreSQL connect=
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
2017 Aug 27
0
Connect to postgreSQL
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
2006 Feb 28
10
Salted hash login, postgresql, unit tests
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
2005 May 11
0
Seshu, on April 20, you said this about the Astcc & AreskiCC --> http://lists.digium.com/pipermail/asterisk-users/2005-April/102710.html Re: AreskiCC installing assistance for seshu.kanuri @ MorganStanley.com
Seshu,
Whats with people who work at Morgan Stanley?
You on the one hand bash the opensource software, and
then on the other hand a few weeks later, ask for
assistance from the open source community for
assistance???????????????????????????????????????????
Today, May 11, you request assistance in installing
the Areski Calling Card platform, after posting
a couple of weeks ago, April 20, this
2005 Oct 03
3
Boolean quoting, postgresql
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
2015 Nov 27
3
LDAP setup on Centos 7
Am 27.11.2015 um 16:53 schrieb Gary Stainburn <gary at ringways.co.uk>:
> Since posting my first email I have re-generated both the root and Manager
> passwords and re-run the setup.
>
> I no longer get the "Invalid credentials" error so presumably the problem must
> have been a cut/paste issue.
>
> I now get the following error. As I am a total newbie to
2014 Apr 26
2
Dovecot cannot connect to PostgreSQL server
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?
2007 Oct 30
4
Postgresql and shell script
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
2010 Sep 01
1
iptables for PostgreSQL not working
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
2005 May 11
2
AreskiCC Install Problems
I have followed the Idiots' guide for installation, but still could not
make it work.
When I try to login at the web page coming from /var/www/html/areski , I
get the following errors:
Can some body give me some hints where and what to check for this
error?. I am looking for info on the changes we have to make for
1) the database name
2) user name
3) password
4)connection name (server