Re: [Phpwebsite-developers] postgres

[Andy H. <ah...@ht...>]

-----BEGIN PGP SIGNED MESSAGE-----


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
On 09-Apr-2003, Don Seiler wrote message "Re: [Phpwebsite-developers] postgres"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Did you specify which database to create it in.  When you ran psql, what 
> command did you specify?
> 
> Don.

yep.  


conf/config.php
<?php
$dbversion = "pgsql";

$dbhost = "localhost";

$dbuser = "xxxxxx";

$dbpass = "xxxxxxxx";

$dbname = "phpws";

$table_prefix = "";

$source_http = "www.nocarbos.com/";

$source_dir = "/var/www/nocarbos/";

$hub_hash = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx";

$install_pw = "xxxxxxxxxx";

?>





> psql -Upgsql phpws 
Welcome to psql 7.3.1, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

phpws=# \l
       List of databases
   Name    | Owner | Encoding  
- -----------+-------+-----------
 phpws     | web   | SQL_ASCII
 template0 | pgsql | SQL_ASCII
 template1 | pgsql | SQL_ASCII
(3 rows)



To create the db, I just did a regular create database command.




~~ 
Andy Harrison
ah##@httpsite.com
ICQ: 123472  AIM/Y!: AHinMaine
[full headers for details]

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQCVAwUBPpQ+9VPEkLgodAWVAQFzWwP+IafoHItTspNdsrGZHbTk1LJRoyx13AVc
RZ3vWk0yi9h0s5kDe8GT4cGhkD/5zg+Tbedz085mSbFglna2Q6sLpKA3jjQki0gt
hvwY2Rm/TYCzmOXOx3677zvv1tCN/hM+NhpKWUEsQcR16SsHP/z3yKlQHoA7NqTG
ElrebweTQf0=
=m8zN
-----END PGP SIGNATURE-----