Re: Problem Connecting to DB After 8.1 Upgrade (SOLVED) - Mailing list pgsql-novice
From | |
---|---|
Subject | Re: Problem Connecting to DB After 8.1 Upgrade (SOLVED) |
Date | |
Msg-id | 20051116174252.54738.qmail@web33315.mail.mud.yahoo.com Whole thread Raw |
In response to | Re: Problem Connecting to DB After 8.1 Upgrade (<operationsengineer1@yahoo.com>) |
List | pgsql-novice |
the upgrade to 8.1 went great... i just missed the *minor* detail of enabling pgsql support in php.ini. excuse me while i go fall on my sword a few times. --- operationsengineer1@yahoo.com wrote: > i'm reinstalling after figuring out i didn't delete > all the pgsql 8.0 files and i didn't configure > php.ini > correctly. > > --- operationsengineer1@yahoo.com wrote: > > > --- Jaime Casanova <systemguards@gmail.com> wrote: > > > > > On 11/14/05, operationsengineer1@yahoo.com > > > <operationsengineer1@yahoo.com> wrote: > > > > --- operationsengineer1@yahoo.com wrote: > > > > > > > > > i have the following adodb code (which > > shouldn't > > > be > > > > > too hard to figure out for those not > familiar > > > with > > > > > adodb): > > > > > > > > > > $db = &ADONewConnection('postgres8'); > > > > > > > > > > > > > > > $db->Connect('localhost','postgres','3mydata5','mydb'); > > > > > if (!$db) die('Connection failed'); > > > > > $db->debug = true; > > > > > > > > > > $sql_product = 'SELECT product_id, > > > product_number > > > > > FROM > > > > > t_product ' . > > > > > 'ORDER BY product_number ASC'; > > > > > > > > > > $sql_employee = 'SELECT employee_id, > > first_name > > > || > > > > > \' > > > > > \' || last_name FROM t_employee ORDER BY > > > > > LOWER(first_name) ASC'; > > > > > > > > > > $db->StartTrans(); > > > > > $rs_product = $db->Execute($sql_product); > > > > > $rs_employee = $db->Execute($sql_employee); > > > > > $db->CompleteTrans(); > > > > > > > > > > $db is true, but i don't think i'm > connecting > > to > > > the > > > > > db. i can echo text prior to the > transaction, > > > but i > > > > > can't echo anything after the transaction. > i > > > > > removed > > > > > the transaction and just left the Execute > > > statements > > > > > - > > > > > same problem. > > > > > > > > > > does anyone have any idea why this isn't > > > working? > > > > > > > > > > tia... > > > > > > > > upon further review, it appears my users and > > > groups > > > > didn't survive the backup and restore > procedure > > > since > > > > pgsql 8.1 is looking for group roles and login > > > roles. > > > > > > > > even so, i don't understand why postgres (a > > > current > > > > login role) is not connecting to the db. > > > > > > > > i will try and mimic my prior setup and go > from > > > there. > > > > > > > > > > > > > > provide some info from your postgres log files > > > (error messages)... > > > > if you could give me the name of the file, i'll > > search > > for it and post the contents. > > > > > have configurated the pg_hba.conf and > > > postgresql.conf? > > > > i don't recall having to do this for 7.4.x (i > might > > have done something TCP/IP related, but that was > it, > > IIRC). did anything change going to 8.1? > > > > > all your users and groups will turn into roles > are > > > you sure you can > > > login from them? > > > > this did not occur in my case - the users and > groups > > didn't transfer. the only role i had in the new > db > > is > > postgres. > > > > i've linked my pg_restore output here.... > > > > > http://www.geocities.com/operationsengineer1/pgsql_restore.xhtml > > > > i created the db then did a restore... i'm not > sure > > if that is the correct procedure. > > > > i tried creating a simple new database with no > > password and i can't connect to it either. > > > > > -- > > > Atentamente, > > > Jaime Casanova > > > (DBA: DataBase Aniquilator ;) > > > > tia for the help... > > > > > > > > __________________________________ > > Start your day with Yahoo! - Make it your home > page! > > > > http://www.yahoo.com/r/hs > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 9: In versions below 8.0, the planner will > > ignore your desire to > > choose an index scan if your joining > column's > > datatypes do not > > match __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com
pgsql-novice by date: