Re: [ADMIN] Cannot connect using psql

2006-10-31 Thread Nick Black
Problem solved. I had config files in /etc/ and in /usr/ . :) On 10/31/06, Nick Black <[EMAIL PROTECTED]> wrote: Hello, I am having difficuilties connected to the postgres server. I asked on IRC, but everyone was stumped, so here we go. My pg_hba.conf file: # TYPE DATABASEUSER

[ADMIN] Cannot connect using psql

2006-10-31 Thread Nick Black
Hello, I am having difficuilties connected to the postgres server. I asked on IRC, but everyone was stumped, so here we go. My pg_hba.conf file: # TYPE DATABASEUSERCIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all

[ADMIN] Uninstalling on Mac OS X 10.4

2006-10-31 Thread Stan Horwitz
A few months ago, I installed Postgress 8 on my Mac to test some software that required it. My testing is done and I need to remove Postgress now, but I cannot find any information on how to do it. All I can find is the original package files, but nothing about unstalling it. I saw in some

Re: [ADMIN] 100% failover + replication solution

2006-10-31 Thread Shoaib Mir
Moiz,H, I think pg_controldata output might help you there to get these stats. pg_controldata can be found in the PostgreSQL /bin folder.Thank you,-Shoaib MirEnterpriseDB ( www.enterprisedb.com)On 10/31/06, Moiz Kothari <[EMAIL PROTECTED]> wrote: Shoaib,This sounds really like what i ne

Re: [ADMIN] [FIXED] Re: can not restart posgresql after dist-upgrade - debian

2006-10-31 Thread Alvaro Herrera
viraj wrote: > hi all, > manged to overcome the issue. the problem was with the shebang line of > the pg_ctlcluster script. > > i replaced the switch '-T' with a '-t', turning Perl's 'tainting > checks' to 'tainting warnings'. Just FYI, pg_ctlcluster is a Debian-specific program, so you should ta

Re: [ADMIN] postgres import

2006-10-31 Thread Adam Radlowski
Achilleas informed You very good. But if Your SQL file comes from other DBMS, like MySQL, You have to a little bit to edit this file, becouse sometimes in those files are used "slangs" characteristical for specific DBMS. If You have SQL file genarated with "pg_dump", You have to be sure, that a

Re: [ADMIN] 100% failover + replication solution

2006-10-31 Thread Moiz Kothari
Shoaib,This sounds really like what i need, but again 8.2 is in beta. Just one question, i dunno if i am thinking in right direction, but is there anyway of finding out the END XID, transaction id and OID of last archived WAL log applied to the database. I was thinking if i can get that value then

Re: [ADMIN] postgres import

2006-10-31 Thread Achilleas Mantzios
Στις Τρίτη 31 Οκτώβριος 2006 10:30, ο/η Antonios Katsikadamos έγραψε: > Hi all, > > > sorry again for the trouble. I have a small problem in postgres, I have a > .sql file ( db dump ) and i want to import it in postgres on linux. > % psql \i .sql > > does anyone know how to do it? > > Thn

[ADMIN] postgres import

2006-10-31 Thread Antonios Katsikadamos
Hi all,     sorry again for the trouble. I have a small problem in postgres, I have a .sql file (  db dump  ) and i want to import it in postgres on linux.     does anyone know how to do it?   Thnx a lot for your time Get your email and more, right on the new Yahoo.com