Out the box installation will get you a system up and running, from there you have a choice of tools you can use such as Navicat to connect to the database. I am assuming you have networked machines. You then can create a new database, tables and populate them with data. The Oracle SGA is truthfully an Oracle feature as it is compromised of a group of Oracle specific structures. A lot of the functionality you get from a SGA in Oracle is closely tied to the operating system with postgres.
Configuration files you can find in the data directory of your postgres installation, postgres.conf would be the most mappable conf file to a init.ora
Running the unix command find postgres.conf will be helpful.
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of kartik
Sent: Wednesday, June 25, 2008 5:01 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Query
Hello there,
I am installing postgresql on debian os.
So can anyone please tell me how to configure it .. and I have few windows clients that needs to be connected to the database server.. can anyone please tell me something about how to configure the server and the client
…
thanks
The information in this email or in any file attached hereto is intended only for the personal and confidential use of the individual or entity to which it is addressed and may contain information that is proprietary and confidential. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communication is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product. Email transmission cannot be guaranteed to be secure or error-free. P6070214