Postgres Pro
Downloads
Home   >   mailing lists

Thread: PostgreSQL on Cygwin on Win98

PostgreSQL on Cygwin on Win98

From
"David A. Cobb"
Date:
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&search=superbiskit>
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.]
<---.----!----.----!----.----!----.----!----.----!----.----!----.---->

Disk space usage with PostgreSQL

From
Jorge Sarmiento
Date:
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

Re: PostgreSQL on Cygwin on Win98

From
Jason Tishler
Date:
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

Re: Disk space usage with PostgreSQL

From
Patrik Kudo
Date:
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:

> 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)
>