[ADMIN] Large scale PostgreSQL deployment.

Not strictly on topic but I guess it is interesting for all of us anyway. I work doing consulting job for a company called DBA Engenharia de Sistemas that works as a contractor for a brazilian government project called "Cadastramento Único" which is a project to centralize all social-related gove

Re: [ADMIN] stupid insert error

Try single quotes (') instead of double-quotes ("). -Bruno On Thu, 23 Jun 2005 17:12:03 -0700, David Bear said: > I guess I'm too stupid to see the error, but I don't understand why > the following fails. > > > insert into person3 (asuid, fname, lname, addedby, addedon, > slopbucket) values (

Re: [ADMIN] Indexes getting corrupted.

Tom Lane wrote: I'm suspicious of a more subtle intermittent error. Yeah, I am too, but so far none of the reporters have been cooperative about providing more information :-( Well, at least from me, I can tell you I gave all information I came up with. One thing that I pointed out is this

Re: [ADMIN] Indexes getting corrupted.

Scott Marlowe wrote: I am having a weird problem here. I have the automated process to install PostgreSQL (8.0.1) on Windows 2000 machines. Besides installing the database server itself, my process does the following: 1 - Runs initdb to created the database I will be using. 2 - Runs a SQL

Re: [ADMIN] Starting PostgreSQL on WinXP is not working

Your Winsock stack is corrupted. You can try to sort it out by using a program called "winsockxpfix". http://www.snapfiles.com/get/winsockxpfix.html -Bruno Rodrigo Katsumoto Sakai wrote: Hi, i'm working with PostgreSQL for a long time (about three years), but always on Linux box. But rec

[ADMIN] Indexes getting corrupted.

I am having a weird problem here. I have the automated process to install PostgreSQL (8.0.1) on Windows 2000 machines. Besides installing the database server itself, my process does the following: 1 - Runs initdb to created the database I will be using. 2 - Runs a SQL script that creates the

[ADMIN] Windows NT 4.0 installation.

Hello. I am not in front of my NT 4.0 machine right now so I won't be able to give any specifics messages or anything at this point. In any case, it seems PostgreSQL can't be installed (via the Windows install package) on Windows NT 4.0 machines, giving an error about missing functions or somet

[ADMIN] Problem with backups and functions.

I am not sure if I am doing something wrong or a hit a bug, so here it goes: I am running PostgreSQL 8.0.1 under Windows 2000. We have this database here which is really small and has a set of 5 functions. All the functions are programmed using pgpsql so we used the functionality where we can us

Re: [ADMIN] Problem with backups and functions.

Hi Tom. Thanks for the reply. I am sure this is not the case. I am doing test dumps on my machine (only PostgreSQL 8.0.1 installed) and the server is also running PostgreSQL 8.0.1. -Bruno Tom Lane wrote: "Bruno G. Albuquerque" <[EMAIL PROTECTED]> writes: The problem is that whe

[ADMIN] Problem with backups and functions.

I am not sure if I am doing something wrong or a hit a bug, so here it goes: I am running PostgreSQL 8.0.1 under Windows 2000. We have this database here which is really small and has a set of 5 functions. All the functions are programmed using pgpsql so we used the functionality where we can use n