Re: Problem Connecting to DB After 8.1 Upgrade

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(at)yahoo(dot)com wrote:

> --- Jaime Casanova <systemguards(at)gmail(dot)com> wrote:
>
> > On 11/14/05, operationsengineer1(at)yahoo(dot)com
> > <operationsengineer1(at)yahoo(dot)com> wrote:
> > > --- operationsengineer1(at)yahoo(dot)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