Re: Questions about server.

From: Richard Huxton <dev(at)archonet(dot)com>
To: max chin <cjh_0711(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Questions about server.
Date: 2005-12-21 09:46:59
Message-ID: 43A92493.40205@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

max chin wrote:
> Dear Mr.,
>
> My name is Chia. I'm a Malaysian student who still persuing my
> computer course. Now I'm working with a IT company for industry
> training. I got some questions about server.

Hi Chia

> 1.) What I knew is when too many users access a database at the same
> time, it will slow down database server process. My question is how
> to make database server process more faster even if a lot of users
> access information in database at the same time? What kind of
> technology is needed to help database server process more faster ?

The first step is to find out *why* it is too slow - not enough memory?
Not enough disk bandwidth? Not enough CPU? Badly planned queries? Badly
written application?

So - the first thing to do is to start monitoring your server closely.

> 2.) In my company, database server and web server are store inside a
> machine. My question is how to separate database server and web
> server from one machine to two machine? I mean how those 2 server
> within one machine will be separated become 1 server within one
> machine, another server within one another machine. Can you show me
> the way or process of implementation?

PostgreSQL allows you to connect to it over an internet connection. You
will need to check settings in your:
1. System firewall
2. postgresql.conf
3. pg_hba.conf (make sure you password-protect access to your database)
Details on 2,3 are in the manuals.

> 3.) How to back up automatically database information from host
> machine to another machine every one hour and everytime update
> database informations is done?

You probably want to read up on pg_dump, point-in-time-recovery (PITR)
and replication (Slony seems popular). See the online manuals and google
for details.

> 4.) Sometimes IIS web server is unavailable and the web pages can' t
> display for clients. Can you tell me the reasons and the methods to
> overcome the problems?

Although there are many people who use IIS in big installations, I'm not
one of them. For maximum reliability, I'd guess Apache on top of one of
the BSD's would be a winner, but probably not an option for you.

> THANKS YOU. CAN YOU GIVE ME YOUR ANSWER AS FAST AS POSSIBLE BECAUSE I
> NEED THESE IMPORTANT ANSWER URGENTLY.

If you're a student on work placement, I'm not sure you should have to
deal with these sort of issues, certainly not urgently.

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Scholz 2005-12-21 11:01:57 Indices for select count(*)?
Previous Message DANTE ALEXANDRA 2005-12-21 09:41:56 Re: out of memory during query execution