Re: [GENERAL][ADMIN][HACKERS]data fragmentation

Hi, I too had the same problem; There was one query which used to take a very long time. What I did was, I took a backup of the whole database. Reinstalled postgres on a different mount point and restored the data back into the new database. Now my queries are running faster. Try it. All the v

Re: [ADMIN] PHP and autocommit of PostgreSQL 7.4

Sai Hertz And Control Systems wrote: > Please vote for this > http://bugs.php.net/26592 Please don't. See my comment. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL][ADMIN][HACKERS]data fragmentation

Hi, i have a theorical question. i was thought that data fragmentation can cause a loss of performance when retrieving data from a database. Some DBMS solved this with dbspaces, but postgresql doesn't support this concept. so, pgsql databases tend to suffer from data fragmentation? if yes, what

[ADMIN] PHP and autocommit of PostgreSQL 7.4

Dear all, Please vote for this http://bugs.php.net/26592 So that in next release of PHP we can set autocommit = off from with in PHP.ini Regards, V Kashyap ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://a

Re: [ADMIN] Problem connecting to psql

Thanks for the reply. I'll take care to keep the same version around. So there is no type of compatibility mode? Feature request maybe? On Thu, 11 Dec 2003 11:12:37 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: Richard Nairn <[EMAIL PROTECTED]> writes: I can run queries, but I can't use some of the

Re: [ADMIN] Problem connecting to psql

Richard Nairn <[EMAIL PROTECTED]> writes: > I can run queries, but I can't use some of the built in functions such as > \d \l. psql's backslash commands generally assume the server is of the same major version as psql. 7.3.2 to 7.2 won't work. regards, tom lane

[ADMIN] Problem connecting to psql

I am trying to connect remotely to my database and I am getting an error: ERROR: parser: parse error at or near "." Welcome to psql 7.3.2 ... I can run queries, but I can't use some of the built in functions such as \d \l. My backend is 7.2. Is this a problem? I am planning on upgrading to 7.4.

Re: [ADMIN] Shutting down pgsql

Mark Warner <[EMAIL PROTECTED]> writes: > Is it possible, advisable, or terribly bad to shutdown a pgsql > database with the do.maintenance script running? You didn't say exactly what that script is doing ... but in general PG queries can be shut down safely. What I'd do is kill the client p

Re: [ADMIN] Help---- Urgent

Create a new column alter add column varchar(25); Then copy the old column into the new column: update set = ; Drop the last column: alter drop column ; Rename the column: alter rename column to ; Take care for INDEXES if there are any. This should do it. Best regards. - Origin

Re: [ADMIN] Running Postgres Daemons with same data files

Bhartendu Maheshwari <[EMAIL PROTECTED]> writes: > I got all your points, thanks for such a great discussion, Now the last > thing I want is how can I close the data files and flush the cache into > the data files. How can I do this in postgresql Shut down the postmaster. > I will also try wi

[ADMIN] Debian Woody backport of PostgreSQL 7.4?

Hi NG! Oliver Elphick had backports of 7.4 on . But this server has been down since the debian hack. I need it urgently. I have been asking in several newsgroups, but did not get a single answer. :( Is there not another source where to get that package

[ADMIN] Seeking PostgreSQL DBA as a Contractor/Consultant position

RadioVoodoo is looking for a DBA with PostgreSQL Exp...if you know of someone or if your looking for consulting work, then please send your resume or call. We are located in Western MA. About 2.5 hours from NYC or Boston, 1.5 from Harvard, CT. Telecommuting is possible. Work Plan consists of th

[ADMIN] Shutting down pgsql

Greetings, Is it possible, advisable, or terribly bad to shutdown a pgsql database with the do.maintenance script running? I have a 12gb db with about 780 tables that has been running maintenance now for approximately 67 hours, and it is beginning to seriously degrade the performance of the

[ADMIN] Help---- Urgent

Dear Sir, I wnat to alter the size of one of the column of a table. How to do this in Postgres ? Plz help me. It's very urgent... I tried with the following syntax : but it failed alter table tablename modify(coumnname varchar(25)); it's very urgnet...plz reply soon.. Thanking you, Regd

Re: [ADMIN] 2CPU 4GBRAM

[EMAIL PROTECTED] ("Jose Mendoza") writes: > How can be efectivly configured the PostgreSQL to run in a machine > with 2 CPUs Xeon 2.4 GHz and 4GB of RAM? The PostgreSQL work with > the 2 processors? > > I had run tests and the tiems is always the same that in a computer > with 1 CPU pentium 4   2.

Re: [ADMIN] error in code

On 10 Dec 2003, [EMAIL PROTECTED] wrote: > I written a code [...] Checking for errors is good: # include # include # include int main() { PGresult *result = NULL; PGconn *conn = NULL; int feild; printf("successful"); conn = PQconnectdb ("ashok"); if

Re: [ADMIN] 2CPU 4GBRAM

[EMAIL PROTECTED] (Peter Eisentraut) writes: > Jose Mendoza wrote: >> I intend to use the postgreSQL in several projects that requiere to >> attend about 1000 - 2500 users in a chain of retail stores. Is is >> that possible? Or is beyond that the postgresql possibilities? > > That is certainly easi

Re: [ADMIN] Postrgres data restoration problem

Jim Cochrane <[EMAIL PROTECTED]> writes: > Anyway, I appreciate you guys' help. I've learned some new things about > postgres. One thing I hope you learned is to run something newer than 7.2.1. If you still want to use the 7.2 series then 7.2.4 is the thing to be using; although really 7.3.5 is t

Re: [ADMIN] Running Postgres Daemons with same data files

On 11 Dec 2003 18:13:07 +0530 Bhartendu Maheshwari <[EMAIL PROTECTED]> wrote: > Dear matt > > Don't joke, this for stopping the Postgres Server. I want close the > files in between the database operations. I am looking for some SQL > command like in Mysql command is 'flush tables'. what's in post

Re: [ADMIN] Running Postgres Daemons with same data files

On Thu, 11 Dec 2003, Matt Clark wrote: > Well I wasn't joking. > > If you want to get the files on disk into a state where they can be modified by a > different postmaster, then you need to shut the > current postmaster down. In theory, maybe, if you only want the second postmaster > to have re

Re: [ADMIN] Running Postgres Daemons with same data files

Well I wasn't joking. If you want to get the files on disk into a state where they can be modified by a different postmaster, then you need to shut the current postmaster down. In theory, maybe, if you only want the second postmaster to have read access, then you could disconnect all users from

Re: [ADMIN] Running Postgres Daemons with same data files

Dear matt Don't joke, this for stopping the Postgres Server. I want close the files in between the database operations. I am looking for some SQL command like in Mysql command is 'flush tables'. what's in postgres? regards bhartendu On Thu, 2003-12-11 at 16:56, Matt Clark wrote: > > I got all yo

Re: [ADMIN] Running Postgres Daemons with same data files

> I got all your points, thanks for such a great discussion, Now the last > thing I want is how can I close the data files and flush the cache into > the data files. How can I do this in postgresql pg_ctl stop ---(end of broadcast)--- TIP