Thread: Maybe Basic Questions ....

Maybe Basic Questions ....

From
"Joao"
Date:
Hello,

I'm New in PostGreSQL so I couldn't yet do much things with this DB.

My Problem is the folwing...

I've a Linux (RedHat 8.0) with PGSQL preinstalled.
The Questions ?
1 - Who to connect to database via ODBC or PGAdmin2.

If I Try to connect with pgadmin2 this error apears :
---------------------
Could not connect to the server;
Could not connect to remote socket.

Check each of the following possible causes of this error:
- The server or port specified is incorrect.

- The client workstation cannot establish a network connection to the
server. Try using 'ping' on the workstation to check the network.

- The server is not listening on a TCP/IP port. Make sure that the
postmaster was started with the -i option, or that tcpip_socket = true is
set in $PGDATA/postgresql.conf.
--------------------------------------
Note : I'Have Comunication getween to computers...(whats wrong ?)

(If I Execute PSQL in Linux it runs OK but i dont know the database name)

2 - Who I Create a new database?

3 - I've downloaded the PGSQL 7.3.3 to install/Upgrade in RH8 but the
message appears :

[pgsqlinst]# ls
postgresql-7.3.3-1PGDG.i386.rpm
postgresql-pl-7.3.3-1PGDG.i386.rpm
postgresql-contrib-7.3.3-1PGDG.i386.rpm
postgresql-python-7.3.3-1PGDG.i386.rpm
postgresql-devel-7.3.3-1PGDG.i386.rpm
postgresql-server-7.3.3-1PGDG.i386.rpm
postgresql-docs-7.3.3-1PGDG.i386.rpm
postgresql-tcl-7.3.3-1PGDG.i386.rpm
postgresql-jdbc-7.3.3-1PGDG.i386.rpm
postgresql-test-7.3.3-1PGDG.i386.rpm
postgresql-libs-7.3.3-1PGDG.i386.rpm
[root@LNXRH8 pgsqlinst]# rpm -i *.rpm
erro: Failed dependencies:       libpthread.so.0(GLIBC_2.3.2) is needed by postgresql-pl-7.3.3-1PGDG       postgresql <
7.3conflicts with postgresql-server-7.3.3-1PGDG
 

Any Idea about this ??


4 - Last Questions   - What Platforms are supported by PostGreSQL ?   - This Database Run in Windows with some stange
way(whats that ?)
 


Tanks a lot,
Jo�o





Re: Maybe Basic Questions ....

From
"Donald Fraser"
Date:
----- Original Message -----
From: "Joao" <joao@inforap.pt>
To: <pgadmin-support@postgresql.org>
Sent: Monday, July 28, 2003 12:48 PM
Subject: [pgadmin-support] Maybe Basic Questions ....


> Hello,
>
> I'm New in PostGreSQL so I couldn't yet do much things with this DB.
>
> My Problem is the folwing...
>
> I've a Linux (RedHat 8.0) with PGSQL preinstalled.
> The Questions ?
> 1 - Who to connect to database via ODBC or PGAdmin2.

pgAdmin2 uses ODBC directly you do not need to set any data sources up using
ODBC.

> If I Try to connect with pgadmin2 this error apears :
> ---------------------
> Could not connect to the server;
> Could not connect to remote socket.
>
> Check each of the following possible causes of this error:
> - The server or port specified is incorrect.
>
> - The client workstation cannot establish a network connection to the
> server. Try using 'ping' on the workstation to check the network.
>
> - The server is not listening on a TCP/IP port. Make sure that the
> postmaster was started with the -i option, or that tcpip_socket = true is
> set in $PGDATA/postgresql.conf.

I would check the option above, it is the most common cause for failure.
If tcp/ip is not set to true then pgAdmin will not connect!
You might want to check the file: $PGDATA/pg_hba.conf as well. This file holds
information about who can connect according to IP address ranges.

> Note : I'Have Comunication getween to computers...(whats wrong ?)
>
> (If I Execute PSQL in Linux it runs OK but i dont know the database name)
If you have not created one then there will only be "template1"

> 2 - Who I Create a new database?
You can create a database once you connect via pgAdmin2

> 3 - I've downloaded the PGSQL 7.3.3 to install/Upgrade in RH8 but the
> message appears :
>
> [pgsqlinst]# ls
> postgresql-7.3.3-1PGDG.i386.rpm
> postgresql-pl-7.3.3-1PGDG.i386.rpm
> postgresql-contrib-7.3.3-1PGDG.i386.rpm
> postgresql-python-7.3.3-1PGDG.i386.rpm
> postgresql-devel-7.3.3-1PGDG.i386.rpm
> postgresql-server-7.3.3-1PGDG.i386.rpm
> postgresql-docs-7.3.3-1PGDG.i386.rpm
> postgresql-tcl-7.3.3-1PGDG.i386.rpm
> postgresql-jdbc-7.3.3-1PGDG.i386.rpm
> postgresql-test-7.3.3-1PGDG.i386.rpm
> postgresql-libs-7.3.3-1PGDG.i386.rpm
> [root@LNXRH8 pgsqlinst]# rpm -i *.rpm
> erro: Failed dependencies:
>         libpthread.so.0(GLIBC_2.3.2) is needed by postgresql-pl-7.3.3-1PGDG
>         postgresql < 7.3 conflicts with postgresql-server-7.3.3-1PGDG
>
> Any Idea about this ??

Not really sure on this one.
What about trying -U option instead of install and also which rpm files did you
down-load - were they built for Redhat 8.0?

> 4 - Last Questions
>     - What Platforms are supported by PostGreSQL ?
>     - This Database Run in Windows with some stange way (whats that ?)
>
It will run on almost any Unix based platform + Mac + windows (via
cigwin) -take your choice.

Regards
Donald Fraser



Re: Maybe Basic Questions ....

From
"Hiroshi Saito"
Date:
Dear Joao.

----- Original Message -----
From: "Joao" <joao@inforap.pt>


> Hello,
>
> I'm New in PostGreSQL so I couldn't yet do much things with this DB.
>
> My Problem is the folwing...
>
> I've a Linux (RedHat 8.0) with PGSQL preinstalled.
> The Questions ?
> 1 - Who to connect to database via ODBC or PGAdmin2.
(snip)
> - The server is not listening on a TCP/IP port. Make sure that the
> postmaster was started with the -i option, or that tcpip_socket = true is
> set in $PGDATA/postgresql.conf.
> --------------------------------------
> Note : I'Have Comunication getween to computers...(whats wrong ?)
>
> (If I Execute PSQL in Linux it runs OK but i dont know the database name)

Did you see the establishment of "pg_hba.conf"?
It will be able to restrict a data base and owner's connection.

>
> 2 - Who I Create a new database?

If authority is given to you, it will be able to be realized with pgadmin2.
It is possible if you are made as follows.
CREATE USER "Joao" CREATEDB;

>
> 3 - I've downloaded the PGSQL 7.3.3 to install/Upgrade in RH8 but the
> message appears :
(snip)
> erro: Failed dependencies:
>         libpthread.so.0(GLIBC_2.3.2) is needed by
postgresql-pl-7.3.3-1PGDG
>         postgresql < 7.3 conflicts with postgresql-server-7.3.3-1PGDG
>
> Any Idea about this ??

see
http://archives.postgresql.org/pgsql-admin/2003-06/msg00005.php

>
>
> 4 - Last Questions
>     - What Platforms are supported by PostGreSQL ?
>     - This Database Run in Windows with some stange way (whats that ?)

It is possible by cygwin supported by a formula.

see
http://www.postgresql.org/docs/faqs/FAQ.html

Regards,
Hiroshi-Saito