[ADMIN] postgresql installation on windows 2000 Pro.

Hi, I am trying to install Postgresql 7.3.4. I downloaded source pack from NET. i am following documentation "Installation on Windows" chapter 2. but due to some error am unable to succeed. flow of my actions: 1. copied and installed cygwin 2. copied and installed cygipc.so my machine have C comp

[ADMIN] changing column size in postgres

hello How do i change the definition of  a column? one of the columns width is not sufficient to store the data. I want to change the width. how to do that in postgres? I tried doing alter table + change/modify. both of them doesn't work in postgres.    and what is the maximum size to which a postg

[ADMIN] a problem

hello How do i change the definition of  a column? one of the columns width is not sufficient to store the data. I want to change the width. how to do that in postgres? I tried doing alter table + change/modify. both of them doesn't work in postgres.    and what is the maximum size to which a post

[ADMIN] Disk Utilization Increases And Time for Vacuum Increases.

= Disk Utilization Increases And Time for Vacuum Increases. = As reported in some threads before the Disk Utilization of Postgres Database increases as time passes. I have taken all th

Re: [ADMIN] template1 database...

The link is very good. But another question. In PostgreSQL, a superuser can modify almost everything in the databases. But I don't think that should be the default. Maybe adding an option is better. When a superuser want to change something owned by the system, he or she can turn the option on, th

Re: [ADMIN] pg_dump does not dump index, constraints, sequences

I have this problem only on ONE DB and not the others so it seems more like an issue only with the pg_dump on that machine, sorry about this. I also noticed that pg_dump -n is no longer supported is there any way to dump data without quotes in PG 7.3.4? On Thu, 2003-08-21 at 07:28, Tom Lane wrote

Re: [ADMIN] undefined reference to `_libintl_gettext'

Hmm... Removing that gettext() call from there fixed the problem. I successfully compiled postgres and installed it. I have also just thought whether it makes much sense to have such a call on a variable name within another call... -s - Original Message - From: "Serguei Mokhov" <[EMAI

[ADMIN] undefined reference to `_libintl_gettext'

Hello, Any insight on what's going on? I'm positive I have all recent gettext stuff installed and configure has detected that. For some reason, the linker says otherwise for pl/PgSQL. That line in pl_exec.c has a call to gettext() ... gcc -O2 -g -Wall -Wmissing-prototypes -Wmissing-declarations -