Tutorial de postgresql

https://www.postgresql.org/docs/9.2/static/auth-pg-hba-conf.html
0.0.0.0/0 representa todas las direcciones IPv4 y :: 0/0 representa todas las direcciones IPv6.
------------ En PGADMIN III al guardar una contraseña sale un mensaje

Indicando que la contraseña del usuario elegido se guardará en un fichero de texto plano, accesible por cualquier aplicación. Si estamos seguros pulsaremos "Aceptar" en la ventana anterior.
http://www.ajpdsoft.com/modules.php?name=News&file=article&sid=490

%APPDATA%\PostgreSQL\pgpass.conf 

-----------------

pgadmin creates the .pgpass file that all libpq programs use to easily 
connect a user to a database. 

-----------------------
COMO CAMBIAR EL PASSWORD DE PGADMIN EN FORMA GRAFICA
http://www.homebrewandtechnology.com/blog/graphicallychangepostgresadminpassword
-------------------------

***************************

Que es un cluster?
Segun video es una instancia de postgresql en el equipo
https://networkfaculty.com/es/video/detail/1062-postgresql---instalacion-basica-en-distribuciones-basadas-en-debian-y-redhat
--------------------

schema
A schema is a named collection of tables. A schema can also contain views, indexes, sequences, data types, operators, and functions. Schemas are analogous to directories at the operating system level, except that schemas cannot be nested. PostgreSQL statement CREATE SCHEMA creates a schema

Advantages of using a Schema

• It allows many users to use one database without interfering with each other.
• It organizes database objects into logical groups to make them more manageable.
• Third-party applications can be put into separate schemas so they do not collide with the names of other objects.

----------------

Problema que me paso

http://postgresql.nabble.com/FATAL-no-pg-hba-conf-entry-for-host-1-td1873063.html
****************

• Why does pgAdmin pick up my IPv6 address and not my normal IP?

down vote

IPv6 is used because you are connecting to localhost. localhost resolves to both 127.0.0.1 and::1. Because operating systems prefer IPv6 over IPv4, that is the reason why IPv6 is used (although on Linux, this can be configured through /etc/gai.conf). The address ::1 is never used as a source address, and you don’t have a global address (2000::/3), which leaves the link-local address (fe80::/10) as the source address. All perfectly logical, normal, expected behaviour when you think about it.

http://dba.stackexchange.com/questions/43608/postgres-connection-access-denied-on-ipv6-address