Re: [ADMIN] Modifying Makefile

2006-10-20 Thread Tom Lane
"Mohamed Yassin Eltabakh" <[EMAIL PROTECTED]> writes: > I updated the src/backend/parser/Makefile and added "new.o" to the OBJS > list, but when I compile I receive error: > undefined reference to `PSQLexec' > undefined reference to `PQntuples' > undefined reference to `PQclear' You s

Re: [ADMIN] Postgre SQL Urgent Help

2006-10-20 Thread Gregory S. Williamson
Apologies for the waste o' bandwidth ... I should clarify that I use cron to run a shell script; that script sets environment variables and what not, and then runs something, a perl script, pg_dump, passing composed SQL to the psql tool, etc.. G -Original Message- From: [EMAIL PROTEC

Re: [ADMIN] Postgre SQL Urgent Help

2006-10-20 Thread Gregory S. Williamson
There is no internal method in PostgreSQL for cron-like jobs. (There has been discussion on this in past mails -- see the archives.) I use an external scheduler (cron since we're a *Nix shop); there are Windows' equivalents but I'm not sure what they are). HTH, Greg Williamson DBA GlobeXplorer

[ADMIN] Version 7.3.8 Upgrade

2006-10-20 Thread Craig W
I have been tasked with investigating an upgrade from 7.3.8 to 8.1.5. I have spent the last 12 years as an Ingres DBA, and am new to PostgreSQL. I know database theory, but not the specifics of this one I am sure that there will be benefits of upgrading, but are there any known problems with upgr

[ADMIN] Developer-Help

2006-10-20 Thread anup ghosh
Sir,        There is a .jar file,a dump file,a .sql file.My question is that how i create a database in PosrgreSQL8.1 in windowsXP platform.Please explain it clearly step by step.       Thankin You  

[ADMIN] Need to repair Database

2006-10-20 Thread Jurado, Hector R.
We use a program that uses GPG file extension, now when the application try to call the database it responds that the database is corrupt. Which tool I could use to repair it?   Normally I need to get old backup and all my new data is lost, the problem begin when some user close the progra

[ADMIN] FastCgi / PostgreSQL: FATAL: Ident authentication failed for user "user_name"

2006-10-20 Thread binberati
Hi, I have a strange problem running Django on a GrokThis.net shared hosting account: Environment: -- Apache/2.0.59 (Unix) mod_fastcgi/2.4.2 PostgreSQL 8.1.3 -- settings.py: -

[ADMIN] Modifying Makefile

2006-10-20 Thread Mohamed Yassin Eltabakh
I'm modifying postgreSQL code and adding a new file (say new.c) under dir "src/backend/parser". This file calls functions (PSQLexec, PQntuples, PQgetvalue, ...). The file looks like: #include "libpq-fe.h" #include "common.h" bool exec_sql() { PGresult *re

[ADMIN] Postgre SQL Urgent Help

2006-10-20 Thread vipin SS
Hello pgsql-admin,    Is it Possible to run a pl/pgsql stored proceedure in a timely manner. ie is it possible to run a resource eating function on midnight please mail me your suggession Best regards,   Vipinss[EMAIL PROTECTED][EMAIL PROTECTED]2006-10-14    Be Confident & Believe in

Re: [ADMIN] openssl config? - SSL Links

2006-10-20 Thread Tomeh, Husam
You may want to check out these SSL-related URLs: SSL - Secure TCP/IP Connections with SSL http://www.postgresql.org/docs/8.1/interactive/ssl-tcp.html SSL - Authentication (pg_hba.conf): http://www.postgresql.org/docs/8.1/interactive/client-authentication.htm l#AUTH-PG-HBA-CONF SSL - Runtime C

Re: [ADMIN] FATAL error frontend message invalid

2006-10-20 Thread Tom Lane
Cedric BUSCHINI <[EMAIL PROTECTED]> writes: > I have a "weird" fatal line in logs: > FATAL: invalid frontend message type 48 48 == ASCII '0', so I'm betting that this represents the backend thinking that a new message starts in the middle of some text. In other words, most likely the client sent

Re: [ADMIN] FATAL error frontend message invalid

2006-10-20 Thread Achilleas Mantzios
Στις Παρασκευή 20 Οκτώβριος 2006 16:05, ο/η Cedric BUSCHINI έγραψε: > Hello all, > > I have a "weird" fatal line in logs: > FATAL: invalid frontend message type 48 > > From what I've found it's from the client (protocol), but I cannot > figure out what is the problem. > > Any one got a clue ? >

[ADMIN] FATAL error frontend message invalid

2006-10-20 Thread Cedric BUSCHINI
Hello all, I have a "weird" fatal line in logs: FATAL: invalid frontend message type 48 From what I've found it's from the client (protocol), but I cannot figure out what is the problem. Any one got a clue ? thx Ceders ---(end of broadcast)