[HACKERS] Urgent

2005-04-18 Thread ElayaRaja S
Hi,
  I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and 
  i have to install postgresql 7.4.5. Plz let me know how to uninstall
completely - postfesql 7.3.2

-- 
Warm Regards,

S.ElayaRaja
Mobile:  (+91) 98450 59540
E-Mail:  [EMAIL PROTECTED] 
[EMAIL PROTECTED]

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq


[HACKERS] Urgent

2005-04-18 Thread ElayaRaja S
Hi,
 I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
 i have to install postgresql 7.4.5. Plz let me know how to uninstall
completely - postfesql 7.3.2

 I am getting as [EMAIL PROTECTED] root]# rpm -e postgresql
error: package postgresql is not installed

if i try to check the version it was displaying
[EMAIL PROTECTED] root]# postgres --version
postgres (PostgreSQL) 7.3.2


-- 
Warm Regards,

S.ElayaRaja
Mobile:  (+91) 98450 59540
E-Mail:  [EMAIL PROTECTED] 
[EMAIL PROTECTED]

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])


[HACKERS] Urgent

2005-04-18 Thread ElayaRaja S
HI, 
Hi,
 I am using Redhat Linux 9, I need to uninstall postfesql 7.3.2 and
 i have to install postgresql 7.4.5. Plz let me know how to uninstall
completely - postfesql 7.3.2

if i install the postgreSQL 7.4.5 and i used the command,
bash-2.05b$ psql
psql: relocation error: psql: undefined symbol: get_progname

plz help me regarding this error. 
psql: relocation error: psql: undefined symbol: get_progname


-- 
Warm Regards,

S.ElayaRaja
Mobile:  (+91) 98450 59540
E-Mail:  [EMAIL PROTECTED] 
[EMAIL PROTECTED]

---(end of broadcast)---
TIP 8: explain analyze is your friend


[HACKERS] pg_hba.conf

2005-04-18 Thread ElayaRaja S
Hi,
 I am using Redhat linux 9. i had configure in pg_hba.conf as
hostpostgres  postgres   10.10.0.76   255.255.255.0   password

If i try to connect with postgresql admin i am getting excpetion as

An erro has occured:

Error connecting to the server: could not connect to server:
Connection refuesed(0x274D/10061)
  Is the server running on host 10.10.0.76 and accepting
  TCP/IP connections on port 5432?
  

Please help me.  

-- 
Warm Regards,

S.ElayaRaja
Mobile:  (+91) 98450 59540
E-Mail:  [EMAIL PROTECTED] 
[EMAIL PROTECTED]

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])


[HACKERS] Urgent

2005-04-17 Thread ElayaRaja S
Hi,
   My postgresql was running successfully in my Redhat LInux 9. After
1 day when i try to login to the folder /usr/local/pgsql/data to
update the ip address i am getting
as 
[EMAIL PROTECTED] data]# ls
Segmentation fault

I am unable to see the files under /usr/local/pgsql/data/,
I need to update the file pg_hba.conf. Plz help me.

-- 
Warm Regards,

S.ElayaRaja
Mobile:  (+91) 98450 59540
E-Mail:  [EMAIL PROTECTED] 
[EMAIL PROTECTED]

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


[HACKERS] Help - Urgent

2005-04-15 Thread ElayaRaja S
Hi,
  I am unable to restart the PostgreSQL. I am using redhat Linux 9
with postgresql 7.4.5. Unexpectedly due to ups problem my server was
shutdown once. After that i am unable to restart the server. How to
stop and start.
  Present status is running. If i tried to start i am getting as

1)  bash-2.05b$ pg_ctl start
pg_ctl: Another postmaster may be running.  Trying to start postmaster anyway.
FATAL:  database files are incompatible with server
DETAIL:  The data directory was initialized by PostgreSQL version 7.3,
which is not compatible with this version 7.4.5.
pg_ctl: cannot start postmaster
Examine the log output.

2)bash-2.05b$ pg_ctl restart
/usr/local/pgsql/bin/pg_ctl: line 274: kill: (5637) - No such process
waiting for postmaster to shut
down
failed
pg_ctl: postmaster does not shut down

3) bash-2.05b$ pg_ctl stop
/usr/local/pgsql/bin/pg_ctl: line 274: kill: (5637) - No such process
waiting for postmaster to shut
down
failed
pg_ctl: postmaster does not shut down


Note: Before my server shutdown i can able to do lot of times start /
stop / restart.
 But now i am unable to stop it. Please help me.


-- 
Warm Regards,

S.ElayaRaja
Mobile:  (+91) 98450 59540
E-Mail:  [EMAIL PROTECTED] 
[EMAIL PROTECTED]

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


[HACKERS] Help - Urgent

2005-04-15 Thread ElayaRaja S
Hi,
 I am unable to restart the PostgreSQL. I am using redhat Linux 9
with postgresql 7.4.5. Unexpectedly due to ups problem my server was
shutdown once. After that i am unable to restart the server. How to
stop and start.
 Present status is running. If i tried to start i am getting as

1)  bash-2.05b$ pg_ctl start
pg_ctl: Another postmaster may be running.  Trying to start postmaster anyway.
FATAL:  database files are incompatible with server
DETAIL:  The data directory was initialized by PostgreSQL version 7.3,
which is not compatible with this version 7.4.5.
pg_ctl: cannot start postmaster
Examine the log output.

2)bash-2.05b$ pg_ctl restart
/usr/local/pgsql/bin/pg_ctl: line 274: kill: (5637) - No such process
waiting for postmaster to shut
down
failed
pg_ctl: postmaster does not shut down

3) bash-2.05b$ pg_ctl stop
/usr/local/pgsql/bin/pg_ctl: line 274: kill: (5637) - No such process
waiting for postmaster to shut
down
failed
pg_ctl: postmaster does not shut down

Note: Before my server shutdown i can able to do lot of times start /
stop / restart.
But now i am unable to stop it. Please help me.


-- 
Warm Regards,

S.ElayaRaja
Mobile:  (+91) 98450 59540
E-Mail:  [EMAIL PROTECTED] 
[EMAIL PROTECTED]

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


[HACKERS] unsubscribe

2005-01-10 Thread ElayaRaja S
approve cFNEGB unsubscribe pgsql-hackers [EMAIL PROTECTED]

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])


[HACKERS] postgresql-7.4.5

2004-12-05 Thread ElayaRaja S
Hi,
I am using postgresql-7.4.5. I nee to use the jdbc connection So i
downloaded 4 versions of driver( pg74.215.jdbc1.jar,
pg74.215.jdbc2.jar, pg74.215.jdbc2ee.jar, pg74.215.jdbc3.jar). I am
uanble to connect it. Please let me know which version of driver i
have to use for postgresql-7.4.5 ?

-- 
Warm Regards,
S.ElayaRaja

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[HACKERS] Help!

2004-11-24 Thread ElayaRaja S
Hi,
While configuring OpenCRX by using Postgresql i am facing probmelm.
The problem while creating db using the command ( createdb -h
localhost -E utf8 -U system crx-CRX ) .
Erro:
createdb: could not connect to database template1: could not connect
to server:
 Connection refused
  Is the server running on host localhost and accepting
  TCP/IP connections on port 5432?

Details of Platfor that i am using:
1) Linux 9
2) Postgre SQL 7.4.5
Note: I have doubt whether the error is due to my existing Postgresql
7.3. Means while installing linux there is built in postgresql 7.3.
But i am installed postgresql 7.4.5. Plz let me know its very urgent.

-- 
Warm Regards,

S.ElayaRaja
Mobile:  98450 59540
E-Mail:   [EMAIL PROTECTED]
 [EMAIL PROTECTED]

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]