[imp] postgresql configuration with Horde/Imp

Nuno Silva nuno_silva@websolut.net
Sat, 24 Mar 2001 02:21:57 +0000
Previous message: [imp] postgresql configuration with Horde/Imp
Next message: probs with stable install
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
hi,

this is from a rh box:

[root@sql /root]# ls -la /etc/rc.d/init.d/post*
-rwxr-xr-x   1 root     root         2442 Feb 16 20:41 
/etc/rc.d/init.d/postgresql
[root@sql /root]#

the command to start postgresql is:
/etc/rc.d/init.d/postgresql start

if you don't have these files reinstall postgresql's rpm files:
mount /mnt/cdrom
cd /mnt/cdrom/RedHat/i386/RPMS/
rpm -Uvh *post*

(or something like this)

then read the docs about creating databases, users, tables, etc

cd /usr/doc/postgresql*
ls -la

then read the docs that came with imp... and then examine the scripts on 
the scripts/ folder.

now, to create databases you need to su to the postgresql user:

su - postgres

then you can create a database:

createdb imp

then you can enter the postgresql "command-line" in database imp:

psql imp

then you can create the tables as described in the scripts dir for 
postgresql

create table .... blah blah blah..

i think you can continue from now on [:)]

good luck,
nuno

Abid Ghufran wrote:

> yes i did install using the RPMs on RedHat but i cant find the 
> postgresql deamon in /etc/rc.d/init.d/ directory. If this is the method 
> to start postgresql then what is that all with the postmaster command 
> and the default user (other than root) with which to run the postgresql 
> command to start the deamon.
> 
> thanks a lot,
> 
> abid ghufran.
> 
> 
> ----Original Message Follows----
> From: Nuno Silva <nuno_silva@websolut.net>
> Reply-To: imp@lists.horde.org
> To: imp@lists.horde.org
> Subject: Re: [imp] postgresql configuration with Horde/Imp
> Date: Thu, 22 Mar 2001 16:27:41 +0000
> MIME-Version: 1.0
> Received: from [199.175.137.150] by hotmail.com (3.2) with ESMTP id 
> MHotMailBC83A872004ED82197D7C7AF89960BC80; Thu Mar 22 12:15:46 2001
> Received: (qmail 24697 invoked by alias); 22 Mar 2001 20:13:37 -0000
> Received: (qmail 24686 invoked from network); 22 Mar 2001 20:13:36 -0000
> 
>>  From imp-return-4717-abidghufran Thu Mar 22 12:17:21 2001
> 
> Mailing-List: contact imp-help@lists.horde.org; run by ezmlm
> Precedence: bulk
> List-Post: <mailto:imp@lists.horde.org>
> List-Help: <mailto:imp-help@lists.horde.org>
> List-Unsubscribe: <mailto:imp-unsubscribe@lists.horde.org>
> List-Subscribe: <mailto:imp-subscribe@lists.horde.org>
> Delivered-To: mailing list imp@lists.horde.org
> Message-ID: <3ABA27FD.7010001@websolut.net>
> User-Agent: Mozilla/5.0 (X11; U; Linux 2.4.2 i686; en-US; 0.7) 
> Gecko/20010112
> X-Accept-Language: en
> References: <F11NH9f7BIJpIlCcLE10000a5a9@hotmail.com>
> 
> 
> Hi,
> 
> have you installed postgresql from stock RedHat RPM's?
> if so all you have to do to start postgresql is:
> /etc/rc.d/init.d/postgresql start
> 
> then you must create the horde tables with "pgsql"; to do this:
> #su - postgres
> $psql
> [and from here follow the instructions on horde/imp to create the
> database and the default tables]
> 
> 
> Good luck,
> Nuno
> 
> 
> 
> Abid Ghufran wrote:
> 
>> 
>> well the follwing errors show that it is not running. when i try to run
>> the command "postmaster" under the bin directory (linux redhat 7) it
>> says that i cant run it with the "root" username, which means as being
>> root. it then says to check the INSTALL file for the information
>> regarding the username under which to run it. i cant seem to find the
>> INSTALL file it is talking about.
>> 
>> how to run it then.
>> 
>> abid ghufran.
>> 
>> ----Original Message Follows----
>> From: Jeff Rebeiro <nix@innocent.com>
>> Reply-To: imp@lists.horde.org
>> To: imp@lists.horde.org
>> Subject: Re: [imp] postgresql configuration with Horde/Imp
>> Date: Thu, 22 Mar 2001 12:29:30 -0500
>> 
>> to find out if the server is running why not just run the client...  
>> if it
>> connects its running.
>> 
>> ----- Original Message -----
>> From: "Abid Ghufran" <abidghufran@hotmail.com>
>> To: <imp@lists.horde.org>
>> Sent: Thursday, March 22, 2001 12:19 PM
>> Subject: [imp] postgresql configuration with Horde/Imp
>> 
>> 
>>  > I am shifting to PostgreSql from MySql. I am getting the follwing 
>> errors
>>  > when i access the test.php3 file at my website. I am trying to verify
>>  > whether the Postgresql server is running or not (as i thnk it isnt).
>> I am
>>  > unable to find the server file under "/etc".
>>  >
>>  > Thank you very much.
>>  >
>>  > Abid Ghufran.
>>  >
>>  > --------------------------------------------------------------------
>>  > Warning: Unable to connect to PostgreSQL server: PQconnectPoll() --
>>  > connect() failed: Connection refused Is the postmaster running 
>> (with -i)
>> at
>>  > 'localhost' and accepting connections on TCP/IP port '5432'? in
>>  > /var/www/horde-phplib/db_pgsql.inc on line 40
>>  >
>>  > Warning: Supplied argument is not a valid PostgreSQL link resource in
>>  > /var/www/horde-phplib/db_pgsql.inc on line 52
>>  >
>>  > Warning: Supplied argument is not a valid PostgreSQL link resource in
>>  > /var/www/horde-phplib/db_pgsql.inc on line 55
>>  >
>>  > Warning: Supplied argument is not a valid PostgreSQL link resource in
>>  > /var/www/horde-phplib/db_pgsql.inc on line 67
>>  > Reload this page to see the counters increment.
>>  > Go back to the test.php3 page.
>>  > View the output of phpinfo().
>>  >
>>  > Per Session Data: 1
>>  > Session ID: 2131237bd7ac2564da44998514305851
>>  > If this page works correctly, then you have a correctly configured
>>  > HordeSession class. You should be done with PHPLIB setup.
>>  > Warning: Unable to connect to PostgreSQL server: PQconnectPoll() --
>>  > connect() failed: Connection refused Is the postmaster running 
>> (with -i)
>> at
>>  > 'localhost' and accepting connections on TCP/IP port '5432'? in
>>  > /var/www/horde-phplib/db_pgsql.inc on line 40
>>  >
>>  > Warning: Supplied argument is not a valid PostgreSQL link resource in
>>  > /var/www/horde-phplib/db_pgsql.inc on line 52
>>  >
>>  > Warning: Supplied argument is not a valid PostgreSQL link resource in
>>  > /var/www/horde-phplib/db_pgsql.inc on line 55
>>  >
>>  > Warning: Supplied argument is not a valid PostgreSQL result 
>> resource in
>>  > /var/www/horde-phplib/db_pgsql.inc on line 122
>>  >
>>  > Warning: Unable to connect to PostgreSQL server: PQconnectPoll() --
>>  > connect() failed: Connection refused Is the postmaster running 
>> (with -i)
>> at
>>  > 'localhost' and accepting connections on TCP/IP port '5432'? in
>>  > /var/www/horde-phplib/db_pgsql.inc on line 40
>>  >
>>  > Warning: Supplied argument is not a valid PostgreSQL link resource in
>>  > /var/www/horde-phplib/db_pgsql.inc on line 52
>>  >
>>  > Warning: Supplied argument is not a valid PostgreSQL link resource in
>>  > /var/www/horde-phplib/db_pgsql.inc on line 55
>>  >
>>  > ---------------------------------------------------------------
>>  >
>>  >
>>  >
>> _________________________________________________________________________
>>  > Get Your Private, Free E-mail from MSN Hotmail at
>> http://www.hotmail.com.
>>  >
>>  >
>>  > --
>>  > IMP mailing list: http://horde.org/imp/
>>  > Frequently Asked Questions: http://horde.org/faq/
>>  > To unsubscribe, mail: imp-unsubscribe@lists.horde.org
>>  >
>>  >
>> 
>> 
>> -- 
>> IMP mailing list: http://horde.org/imp/
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: imp-unsubscribe@lists.horde.org
>> 
>> 
>> _________________________________________________________________________
>> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
> 
> 
> 
> -- 
> IMP mailing list: http://horde.org/imp/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org
> 
> 
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Previous message: [imp] postgresql configuration with Horde/Imp
Next message: probs with stable install
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]