Re: [ADMIN] Problem starting up PostgreSQL 8.0 database service in Windows 2003 server

2006-12-07 Thread ron
Hi guys, I appreciate much all your help on this one. The user account postgres which I used to startup the PostgreSQL db service has been misgrouped in the Administrators group. All things well now. Many thanks! ron On 12/8/06, ron <[EMAIL PROTECTED]> wrote: Please kindly help me with this

Re: [ADMIN] Should clients warn in case of server version mismatch ?

2006-12-07 Thread Rajesh Kumar Mallah
On 12/8/06, Adam Radlowski <[EMAIL PROTECTED]> wrote: I had problem such this. I've got 8.1.3 client and 8.0.6 server. But psql 8.1.3 warned me, that some \? functions can not work properly. I've resolved this problem in very simply way. thanks. my problem is resolved as i mantain symbolic link

Re: [ADMIN] Should clients warn in case of server version mismatch

2006-12-07 Thread Adam Radlowski
I had problem such this. I've got 8.1.3 client and 8.0.6 server. But psql 8.1.3 warned me, that some \? functions can not work properly. I've resolved this problem in very simply way. I got binary psql from 8.0.x and run. Psql program is a client program, that uses libpq library, so it is (I th

[ADMIN] Looking for PG professionals

2006-12-07 Thread Ritu Khetan
Hello friends, CRISIL is a leading Ratings, Research, Risk and Policy Advisory company based in Mumbai, India. We are currently looking for professionals skilled in the management of Postgres who can work with us on some of our critical financial services solutions. He/she should be well verse

Re: [ADMIN] Should clients warn in case of server version mismatch ?

2006-12-07 Thread Rajesh Kumar Mallah
On 12/8/06, Tom Lane <[EMAIL PROTECTED]> wrote: "Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes: > We connected psql 8.2.0 accidently to postmaster ver 8.1.5. > \d tablename does not work. > should psql at least warn like pg_dump does in case > of such client server version mismatches ? Um, did

Re: [ADMIN] Should clients warn in case of server version mismatch ?

2006-12-07 Thread Tom Lane
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes: > We connected psql 8.2.0 accidently to postmaster ver 8.1.5. > \d tablename does not work. > should psql at least warn like pg_dump does in case > of such client server version mismatches ? Um, did you read the banner? $ ~/version82/bin/psql -p 5

[ADMIN] Should clients warn in case of server version mismatch ?

2006-12-07 Thread Rajesh Kumar Mallah
Hi, We connected psql 8.2.0 accidently to postmaster ver 8.1.5. \d tablename does not work. should psql at least warn like pg_dump does in case of such client server version mismatches ? regds mallah. ---(end of broadcast)--- TIP 9: In versions b

Re: [ADMIN] pgdump

2006-12-07 Thread Rajesh Kumar Mallah
On 12/8/06, anuradha devi <[EMAIL PROTECTED]> wrote: Hi I have a pgdump.sql file and i want to restore it.The postgreSQL database server is running and i issue the command psql -U postgres pgdump.sql in the command prompt. i get the following error. C:\Program Files\PostgreSQL\8.2\bin>psql -U pos

[ADMIN] pgdump

2006-12-07 Thread anuradha devi
Hi I have a pgdump.sql file and i want to restore it.The postgreSQL database server is running and i issue the command psql -U postgres pgdump.sql in the command prompt. i get the following error. C:\Program Files\PostgreSQL\8.2\bin>psql -U postgres pgdump.sql psql: could not connect to serve

Re: [ADMIN] Problem starting up PostgreSQL 8.0 database service in Windows 2003 server

2006-12-07 Thread Rajesh Kumar Mallah
On 12/7/06, ron <[EMAIL PROTECTED]> wrote: Please kindly help me with this problem I am experiencing with starting up a PostgreSQL 8.0 db service in a Windows 2003 server. Whenever I attempt to restart the service I always get the message: "The PostgreSQL Database Server 8.0 on Local Computer s

[ADMIN] Problem starting up PostgreSQL 8.0 database service in Windows 2003 server

2006-12-07 Thread ron
Please kindly help me with this problem I am experiencing with starting up a PostgreSQL 8.0 db service in a Windows 2003 server. Whenever I attempt to restart the service I always get the message: "The PostgreSQL Database Server 8.0 on Local Computer started and then stopped. Some services stop a

Re: [ADMIN] problem in logging into database

2006-12-07 Thread Rajesh Kumar Mallah
On 12/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: I am new to using postgres. I working on version 8.0. I have created a number of users in the database but I am not able to log into it using any of them, Hi, Could you please paste the ERROR message you get. regds mallah. where in

Re: [ADMIN] problem in logging into database

2006-12-07 Thread Adam Radlowski
Did You specified the database ? In PostgreSQL You are logging into database, not into DBMS, like in MySQL. For test users try template1 first, for example psql -h yourhost -U somebody -d template1 Did You grant those users rights to database wchich they are connecting to ? Regards Adam [EMAIL

[ADMIN] problem in logging into database

2006-12-07 Thread ankit . mehrotra
I am new to using postgres. I working on version 8.0. I have created a number of users in the database but I am not able to log into it using any of them, where in logging into using user postgres is successfull the commands that i am using are -- createuser -a -d -P "username" for loggi

Re: [ADMIN] Recovery plan for DRDB setup - recovery tool

2006-12-07 Thread Peter Eisentraut
Morten Andersen wrote: > So are there any Postgresql tools for analyzing and repairing the > "offline" database files (like e.g. the MySQL 'myisamchk'-tool). No. > So, how do other DRDB Postgresql sites handles failovers. Do you do > anything pro-active on the slave before starting Postgresql, or

[ADMIN] Recovery plan for DRDB setup - recovery tool

2006-12-07 Thread Morten Andersen
Hello, We are analyzing a master-slave setup of Postgresql 8.1 using DRDB (v.0.7, type 'C'), and judging from the mailing list, this setup is succesfully in production at several places. Our initial tests also shows that the failovers are problem free. But we would like to have a plan for how to