Re: [ADMIN] Install Tsearch2

I am getting the follow error: analise3:/postgres/share/contrib/tsearch2 # make Makefile:31: ../../src/Makefile.global: No such file or directory Makefile:32: /contrib/contrib-global.mk: No such file or directory make: *** No rule to make target `/contrib/contrib-global.mk'. Stop.

Re: [ADMIN] Install Tsearch2

Στις Παρασκευή 02 Φεβρουάριος 2007 14:05, ο/η Alexander B. έγραψε: I am getting the follow error: analise3:/postgres/share/contrib/tsearch2 # make Makefile:31: ../../src/Makefile.global: No such file or directory Makefile:32: /contrib/contrib-global.mk: No such file or directory make: *** No

Re: [ADMIN] Install Tsearch2

yes, you need to just correct the build directory paths... --- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 2/2/07, Achilleas Mantzios [EMAIL PROTECTED] wrote: Στις Παρασκευή 02 Φεβρουάριος 2007 14:05, ο/η Alexander B. έγραψε: I am getting the follow error:

[ADMIN] Postgres is not starting or stopping

Hi all, I have two production server .One ia already live and the other is going to live soon. In the 1st server i have postgres 7.4.6 and having no problem In the second server we have postgres (PostgreSQL) 7.4.15. Here i have made a mistake. I have removed

Re: [ADMIN] Install Tsearch2

Am Freitag, 2. Februar 2007 13:05 schrieb Alexander B.: I am getting the follow error: analise3:/postgres/share/contrib/tsearch2 # make Makefile:31: ../../src/Makefile.global: No such file or directory Makefile:32: /contrib/contrib-global.mk: No such file or directory make: *** No rule to

Re: [ADMIN] Postgres is not starting or stopping

If you can tell the specific error on start/stop then someone might be able to help you with this... -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 2/2/07, Manish Pillai [EMAIL PROTECTED] wrote: Hi all, I have two production server .One ia already live and the other is going to

Re: [ADMIN] Postgres is not starting or stopping

Hi, I am getting only this much... [EMAIL PROTECTED] init.d]# ./postgresql restart Stopping postgresql service: [FAILED] Starting postgresql service: [FAILED] [EMAIL PROTECTED] init.d]# How to enable log

Re: [ADMIN] Postgres is not starting or stopping

Instead of starting with the service, trying starting up with 'postmaster' binary. It can be found in the database server 'bin' folder and that should give a little more detail failure message. To enable logging please go through -- 16.4.5. Error Reporting and Logging at

Re: [ADMIN] Postgres is not starting or stopping

I have installed it using rpm..So bin folder is not available inside pgsql :-( Manish Shoaib Mir [EMAIL PROTECTED] wrote: Instead of starting with the service, trying starting up with 'postmaster' binary. It can be found in the database server 'bin' folder and that should

Re: [ADMIN] Postgres is not starting or stopping

You will always have a postmaster binary - do a find / -name postmaster to find it. If your secondary production server hasn't gone live yet, I'd seriously consider starting it up on the 8.2 series. Manish Pillai wrote: I have installed it using rpm..So bin folder is not available inside

Re: [ADMIN] ADMIN Install Tsearch2 - new dic

Sorry for insist, but how can I add a new language, specially portuguese? I could execute the file tsearch2.sql, but I need to configure in my language. Thanks in advance. Jeff Frost escreveu: BTW, this was for an RPM installed version of postgresql. As Shoab mentions in another mail, if

Re: [ADMIN] ADMIN Install Tsearch2 - new dic

Le vendredi 2 février 2007 17:28, Alexander B. a écrit : Sorry for insist, but how can I add a new language, specially portuguese? I could execute the file tsearch2.sql, but I need to configure in my language. you should look at the tsearch2 site, there is a lot of info. in few steps : - use

Re: [ADMIN] Postgres is not starting or stopping

I am getting only this much... [EMAIL PROTECTED] init.d]# ./postgresql restart Stopping postgresql service: [FAILED] Starting postgresql service: [FAILED] [EMAIL PROTECTED] init.d]# How to enable log in

Re: [ADMIN] Postgres is not starting or stopping

Shane Ambler wrote: I am getting only this much... [EMAIL PROTECTED] init.d]# ./postgresql restart Stopping postgresql service: [FAILED] Starting postgresql service: [FAILED] [EMAIL PROTECTED] init.d]# How to

Re: [ADMIN] Postgres is not starting or stopping

Joshua D. Drake [EMAIL PROTECTED] writes: Shane Ambler wrote: Your prob may be knowing where the log is. By default you will find it in your data directory along with postgresql.conf and it will be called serverlog likely /var/log/postgresql What linux is this? There are enough different

Re: [ADMIN] Terminating a query that appears to be hung

Thank you for the response. We are using Linux and I am able to identify the offending pid. I was not sure if killing the process was an acceptable and safe practice. Thanks again! Robert Guido Barosio wrote: Hmm, if you are a sysadmin you may want to get the process id for the query,

[ADMIN] pg_dumpall failure - could not access status of transaction

I am attempting to get a handle on the corruption that caused the following error: pg_dump: SQL command failed pg_dump: Error message from server: ERROR: could not access status of transaction 3183024 DETAIL: could not open file pg_clog/0003: No such file or directory pg_dump: The command was:

[ADMIN] DST changes for 2007

Hello, I was wondering if there is some patch to apply for Postgres to handle the changes in the daylight savings time for 2007. Thanks Abu - Need Mail bonding? Go to the Yahoo! Mail QA for great tips from Yahoo! Answers users.

Re: [ADMIN] pg_dumpall failure - could not access status of transaction

I wrote: I am attempting to get a handle on the corruption that caused the following error... After a bit more digging I found a couple of old messages that helped - http://archives.postgresql.org/pgsql-admin/2004-01/msg00258.php The last tuple that is valid is (3, 123) and looking at record 3

Re: [ADMIN] DST changes for 2007

See the FAQ on the web site. --- Abu Mushayeed wrote: Hello, I was wondering if there is some patch to apply for Postgres to handle the changes in the daylight savings time for 2007. Thanks Abu

Re: [ADMIN] pg_dumpall failure - could not access status of transaction

Robert Leftwich wrote: pg_dump: Error message from server: ERROR: could not access status of transaction 3183024 DETAIL: could not open file pg_clog/0003: No such file or directory If your database system has already experienced on the order of 3183024 transactions, then you should wonder

Re: [ADMIN] pg_dumpall failure - could not access status of transaction

Robert Leftwich [EMAIL PROTECTED] writes: On Fri, 02 Feb 2007 21:21:47 -0500, Tom Lane [EMAIL PROTECTED] said: Also, can you show us the pg_filedump output for the page of pg_description you think is trashed? I find -i -f options give the most useful output usually. [ dump snipped ] Yeah,

[ADMIN] Backup Strategies?

Hello All, What strategies are people using for automated, script-based backup of databases? There are a few I can think of: 1. Create a db_backup unix user and a db_backup pgsql user. Grant READ access to all objects on all databases for the db_backup pgsql user. Create a .pgpass file