| 1 |
Hola muchachos, |
| 2 |
tengo que instalar postgresql, la instalacion anda el ebuild esta bien, |
| 3 |
pero no puedo acceder a la misma una ves instalada a traves de |
| 4 |
phppgadmin, me parece que es un tema de que no acepta las conecciones la |
| 5 |
base de datos, aparte de que .. con que usauario por defecto se instala? |
| 6 |
|
| 7 |
Alguien tiene experiencia instalando y seteando correctamente el |
| 8 |
postgreSQL, como para que me de algunas pautas de en que estoy mal? |
| 9 |
|
| 10 |
<quote> |
| 11 |
|
| 12 |
* >>> Execute the following command |
| 13 |
* >>> ebuild /var/db/pkg/dev-db/postgresql-7.3/postgresql-7.3.ebuild |
| 14 |
config |
| 15 |
* >>> to setup the initial database environment. |
| 16 |
* >>> |
| 17 |
* >>> Make sure the postgres user in /etc/passwd has an account setup |
| 18 |
with /bin/bash as the shell, or /bin/true |
| 19 |
|
| 20 |
envivo / # ebuild |
| 21 |
/var/db/pkg/dev-db/postgresql-7.3/postgresql-7.3.ebuild config |
| 22 |
* >>> Creating data directory ... |
| 23 |
* >>> Initializing the database ... |
| 24 |
The files belonging to this database system will be owned by user |
| 25 |
"postgres". |
| 26 |
This user must also own the server process. |
| 27 |
|
| 28 |
The database cluster will be initialized with locale C. |
| 29 |
|
| 30 |
Fixing permissions on existing directory /var/lib/postgresql/data... ok |
| 31 |
creating directory /var/lib/postgresql/data/base... ok |
| 32 |
creating directory /var/lib/postgresql/data/global... ok |
| 33 |
creating directory /var/lib/postgresql/data/pg_xlog... ok |
| 34 |
creating directory /var/lib/postgresql/data/pg_clog... ok |
| 35 |
creating template1 database in /var/lib/postgresql/data/base/1... ok |
| 36 |
creating configuration files... ok |
| 37 |
initializing pg_shadow... ok |
| 38 |
enabling unlimited row size for system tables... ok |
| 39 |
initializing pg_depend... ok |
| 40 |
creating system views... ok |
| 41 |
loading pg_description... ok |
| 42 |
creating conversions... ok |
| 43 |
setting privileges on built-in objects... ok |
| 44 |
vacuuming database template1... ok |
| 45 |
copying template1 to template0... ok |
| 46 |
|
| 47 |
Success. You can now start the database server using: |
| 48 |
|
| 49 |
/usr/bin/postmaster -D /var/lib/postgresql/data |
| 50 |
or |
| 51 |
/usr/bin/pg_ctl -D /var/lib/postgresql/data -l logfile start |
| 52 |
|
| 53 |
* If you are upgrading from a pre-7.3 version of PostgreSQL, please |
| 54 |
read |
| 55 |
* the README.adddepend file for information on how to properly migrate |
| 56 |
* all serial columns, unique keys and foreign keys to this version. |
| 57 |
|
| 58 |
envivo / # cat /etc/passwd | grep postgres |
| 59 |
postgres:x:70:70::/var/lib/postgresql:/bin/bash |
| 60 |
|
| 61 |
envivo / # /etc/init.d/postgresql start |
| 62 |
* Starting |
| 63 |
postgres... [ ok ] |
| 64 |
|
| 65 |
</quote> |
| 66 |
|
| 67 |
No puedo cambiarlo siendo root? |
| 68 |
|
| 69 |
envivo / # passwd postgres |
| 70 |
passwd: Authentication token manipulation error |
| 71 |
envivo / # |
| 72 |
|
| 73 |
O por ej. como agrego un user que si pueda administrarlo a traves |
| 74 |
de phppgadmin :s |
| 75 |
|
| 76 |
Si alguien me puede tirar un salvavidas que me avise :) |
| 77 |
cheers. |
| 78 |
|
| 79 |
-- |
| 80 |
Cesar Bermudez <bermudez@××××××.com> |
| 81 |
|
| 82 |
|
| 83 |
-- |
| 84 |
gentoo-user-es@g.o mailing list |
Archives