PostgreSQL on Cygwin on Win98

Started by David A. Cobbalmost 25 years ago4 messagesgeneral
Jump to latest
#1David A. Cobb
superbiskit@home.com

The PostgreSQL documentation says the server portion doesn't work on
Win98. I run
Cygwin on Win98 -- does that provide the needed threading support to run
the server?

David A. Cobb, Software Engineer, Public Access Advocate, All around nice guy.
Get my PGP key at
:<http://pgpkeys.mit.edu:11371/pks/lookup?op=get&amp;search=superbiskit&gt;
Fingerprint=0x{6E3E_DB8C_2E8C_4248_62B2_FE29_08EE_CF0A_3629_E954}
"By God's Grace I am a Christian man, by my actions a great sinner."
--The Way of a Pilgrim, R. M. French [tr.]
<---.----!----.----!----.----!----.----!----.----!----.----!----.---->

#2Jorge Sarmiento
jsarmiento@ccom.org
In reply to: David A. Cobb (#1)
Disk space usage with PostgreSQL

I have noticed that postgresql is constantly using more and more disk space
and I have not inserted any data. It has growth from 18% usage to 44% usage

I do everyday a vacuum; and vacuum analyze; to my database...

how can I stop this? at this rate I will soon be out of disk space...

thanks to all for you answers!

Jorge Sarmiento

#3Patrik Kudo
kudo@partitur.se
In reply to: Jorge Sarmiento (#2)
Re: Disk space usage with PostgreSQL

Hi,

Do you have logging switched on? It sounds to me as if you have a logfile
which grows.

Regards,
Patrik Kudo

ech`echo xiun|tr nu oc|sed 'sx\([sx]\)\([xoi]\)xo un\2\1 is xg'`ol
K�nns det oklart? Fr�ga p�!

On Mon, 28 May 2001, Jorge Sarmiento wrote:

Show quoted text

I have noticed that postgresql is constantly using more and more disk space
and I have not inserted any data. It has growth from 18% usage to 44% usage

I do everyday a vacuum; and vacuum analyze; to my database...

how can I stop this? at this rate I will soon be out of disk space...

thanks to all for you answers!

Jorge Sarmiento

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

#4Jason Tishler
Jason.Tishler@dothill.com
In reply to: David A. Cobb (#1)
Re: PostgreSQL on Cygwin on Win98

David,

On Mon, May 28, 2001 at 02:47:32PM -0400, David A. Cobb wrote:

The PostgreSQL documentation says the server portion doesn't work on
Win98.

Just curious, but what part of the documentation states that the server
doesn't work on Windows 98? I have seen documentation that PostgreSQL
runs on Windows NT and 2000, but I have yet to find something specifically
pertaining to Windows 9X/Me.

I run
Cygwin on Win98 -- does that provide the needed threading support to run
the server?

I don't believe that threading is relevant since PostgreSQL does not
use threads -- PostgreSQL uses the traditional UNIX dispatcher (fork/exec
child worker) model.

Nevertheless, PostgreSQL does work under Windows 98 with some caveats.
See the follow for some of them:

http://www.ca.postgresql.org/mhonarc/pgsql-cygwin/2001-05/msg00065.html

I casually ran PostgreSQL under Windows 98 last fall during the 7.0.2
time frame just for academic interest. The general consensus seems to
indicate that although PostgreSQL runs under Windows 98, it should only
be used for development or as a way to learn PostgreSQL. IMO, one should
only deploy under Windows NT or 2000.

Even some of the core PostgreSQL development team didn't seem to realize
that PostgreSQL runs under Windows 98 until recently:

http://www.ca.postgresql.org/mhonarc/pgsql-ports/2001-02/msg00010.html

Jason

--
Jason Tishler
Director, Software Engineering Phone: 732.264.8770 x235
Dot Hill Systems Corp. Fax: 732.264.8798
82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA WWW: http://www.dothill.com