[ADMIN] issue with Postgres uninstallation

Hi, I have Postgres 8.1.4 installation and now I want to uninstall. I have run the command rm -r postgres packages(all). Here I am unable to rum rpm -e package name to uninstall the postgres 8.1.4. Can you please help me to clean the installed Postgres environment(Uninstall). Thanks

[ADMIN] How To: LARGE html text or csv file COPY FROM?

Hello Friends, We're trying something for the first time: A COPY into a database, from a TEXT (or CSV) file containing one really, really, big field of html. The field happens to be content of complete webpages, which we then need to later analyze, slice, dice, etc. - so it's verbatim

Re: [ADMIN] issue with Postgres uninstallation

Anuj Pankaj an...@cybage.com writes: I have Postgres 8.1.4 installation and now I want to uninstall. I have run the command rm -r postgres packages(all). Er, rm not rpm? Exactly what files did you delete here? Here I am unable to rum rpm -e package name to uninstall the postgres 8.1.4.

Re: [ADMIN] issue with Postgres uninstallation

On Wed, 2010-09-15 at 15:09 +0530, Anuj Pankaj wrote: Here I am unable to rum rpm -e package name to uninstall the postgres 8.1.4. What is the error message that you are getting? -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository:

[ADMIN] information_schema.role_table_grants differs from relacl

Hello, there seems to be a difference between information_schema and pg_catalog when it comes to privileges. pg_class and pgAdmin III show ACL = arwdDxt pgAdmin III displays this as: GRANT ALL ON TABLE blabla.tabelle TO benutzer; However, information_schema.role_table_grants has is_grantable

Re: [ADMIN] information_schema.role_table_grants differs from relacl

Jan-Peter Seifert jan-peter.seif...@gmx.de writes: there seems to be a difference between information_schema and pg_catalog when it comes to privileges. pg_class and pgAdmin III show ACL = arwdDxt pgAdmin III displays this as: GRANT ALL ON TABLE blabla.tabelle TO benutzer; However,

[ADMIN] can you change pg_hba.conf and restart the listener on the fly?

Hi We are running an 8.3.10 instance. I need to make a change to pg_hba.conf on the fly. Is it possible to restart just the listener for the database without cycling the postmaster? Mr

Re: [ADMIN] can you change pg_hba.conf and restart the listener on the fly?

Mark Rostron mrost...@ql2.com writes: We are running an 8.3.10 instance. I need to make a change to pg_hba.conf on the fly. Is it possible to restart just the listener for the database without cycling the postmaster? There is no separate listener. However, it's sufficient to SIGHUP the

Re: [ADMIN] can you change pg_hba.conf and restart the listener on the fly?

Mark Rostron mrost...@ql2.com wrote: I need to make a change to pg_hba.conf on the fly. Is it possible to restart just the listener for the database without cycling the postmaster? pg_ctl reload That will also pick up changes to postgresql.conf, but it won't interrupt execution of the

Re: [ADMIN] How To: LARGE html text or csv file COPY FROM?

Lou Picciano wrote:p { margin: 0; } Both errors above make sense to me; COPY is running into either a cr or a tab character in each case. Even though they might seem very similar at first, text mode and CSV mode work very differently here. To quote TFM at

Re: [ADMIN] issue with Postgres uninstallation

To install Postgres I created a folder Postgres and I kept all packages and I installed Postgres from these packages. To Uninstall Me suppose, I have to run rpm -e each packages name. Here mistakenly I removed all packages.I I am still able to login in Postgres. Please help me to uninstall