Обсуждение: Query

Поиск
Список
Период
Сортировка

Query

От
"kartik"
Дата:

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

Re: Query

От
Travis Smith
Дата:

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

Re: Query

От
"Kevin Grittner"
Дата:
>>> "kartik" <kartik@v2technocrats.com> wrote:

> 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

The PostgreSQL documentation is quite good.  Start here:

http://www.postgresql.org/docs/8.3/interactive/index.html

You might want to read through the tutorial first.

Regarding the connections from other machines, see:

http://www.postgresql.org/docs/8.3/interactive/runtime-config-connection.html

-Kevin

Re: Query

От
Carol Walter
Дата:
Greetings,

While the online documentation is the definitive document, I've found the Apress book Beginning Databases with PostgreSQL: From Novice to Professional very helpful.  There is a section on connecting to computers using a variety of languages.

Carol Walter

On Jun 25, 2008, at 11:11 AM, Kevin Grittner wrote:

"kartik" <kartik@v2technocrats.com> wrote: 

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

The PostgreSQL documentation is quite good.  Start here:


You might want to read through the tutorial first.

Regarding the connections from other machines, see:


-Kevin

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription: