[HACKERS] Urgent
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
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
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
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
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
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
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
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
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!
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]