Portál AbcLinuxu, 12. května 2025 14:30
Finally you need to install the OutKafe database schema into the database. This schema is available as an SQL script.Problém ale nastáva v tom, že neviem ako tú schému čo som si stiahol "outkafe.sql" nahrať do postgrepSQL servera aby ju používal. Mám nainštalovaný aj pgAdmin3 ale nepodarilo sa mi to cez neho :( Za každú radu budem mooc vďačný a predom ďakujem.
man psql a Google, nie abclinuxu.cz. 
Tak dúfam, že som Ti trošku objasnil moju situáciu
S pozdravom :)su - postgres (kedze som prihlásený ako uživateľ server) /home/postgres/PostgreSQL/bin/postmaster -D /home/postgres/PGDATAa až potom môžem spustiť Outcafe. No a ja by som potreboval aby sa mi postgresql server spustil pri štarte. Outcafe som si už nastavil do `/.kde/Autostart takže sa mi spúšťa automaticky pri štarte KDE, ale neviem kam nastaviť aby sa mi spúšťal aj postgresql pri štarte. Skúšal som do /etc/rc.local
potom#!/bin/sh -e # ### BEGIN INIT INFO # Provides: rc.local # X-Mandriva-Compat-Mode # Default-Start: 2 3 4 5 # Short-Description: Local initialization script # Description: This script will be executed *after* all the other init scripts. # You can put your own initialization stuff in here if you don't # want to do the full Sys V style init stuff. ### END INIT INFO /home/postgres/PostgreSQL/bin//postmaster -D /home/postgres/PGDATA
chmod +x /etc/rc.localale nepomohlo to. Neviete kde by sa to dalo nastavit? Predom vďaka za odpovede.
[server@server ~]$ rpm -ql postgresql /etc/rpm/macros.d/postgresql.macros /etc/sysconfig/mdkpg /usr/bin/clusterdb /usr/bin/createdb /usr/bin/createlang /usr/bin/createuser /usr/bin/dropdb /usr/bin/droplang /usr/bin/dropuser /usr/bin/mdk_pg /usr/bin/pg_dump /usr/bin/pg_dumpall /usr/bin/pg_restore /usr/bin/psql /usr/bin/reindexdb /usr/bin/vacuumdb /usr/share/doc/postgresql-8.2.4 /usr/share/doc/postgresql-8.2.4/COPYRIGHT /usr/share/doc/postgresql-8.2.4/FAQ /usr/share/doc/postgresql-8.2.4/HISTORY /usr/share/doc/postgresql-8.2.4/KNOWN_BUGS /usr/share/doc/postgresql-8.2.4/MISSING_FEATURES /usr/share/doc/postgresql-8.2.4/README /usr/share/doc/postgresql-8.2.4/README.mb.big5 /usr/share/doc/postgresql-8.2.4/README.mb.jp /usr/share/doc/postgresql-8.2.4/bug.template /usr/share/locale/af/LC_MESSAGES/libpq.mo /usr/share/locale/cs/LC_MESSAGES/initdb.mo /usr/share/locale/cs/LC_MESSAGES/libpq.mo /usr/share/locale/cs/LC_MESSAGES/pg_config.mo /usr/share/locale/cs/LC_MESSAGES/pg_ctl.mo /usr/share/locale/cs/LC_MESSAGES/pg_dump.mo /usr/share/locale/cs/LC_MESSAGES/pgscripts.mo /usr/share/locale/cs/LC_MESSAGES/psql.mo /usr/share/locale/de/LC_MESSAGES/initdb.mo /usr/share/locale/de/LC_MESSAGES/libpq.mo /usr/share/locale/de/LC_MESSAGES/pg_config.mo /usr/share/locale/de/LC_MESSAGES/pg_ctl.mo /usr/share/locale/de/LC_MESSAGES/pg_dump.mo /usr/share/locale/de/LC_MESSAGES/pgscripts.mo /usr/share/locale/de/LC_MESSAGES/psql.mo /usr/share/locale/es/LC_MESSAGES/initdb.mo /usr/share/locale/es/LC_MESSAGES/libpq.mo /usr/share/locale/es/LC_MESSAGES/pg_config.mo /usr/share/locale/es/LC_MESSAGES/pg_ctl.mo /usr/share/locale/es/LC_MESSAGES/pg_dump.mo /usr/share/locale/es/LC_MESSAGES/pgscripts.mo /usr/share/locale/es/LC_MESSAGES/psql.mo /usr/share/locale/fa/LC_MESSAGES/psql.mo /usr/share/locale/fr/LC_MESSAGES/initdb.mo /usr/share/locale/fr/LC_MESSAGES/libpq.mo /usr/share/locale/fr/LC_MESSAGES/pg_config.mo /usr/share/locale/fr/LC_MESSAGES/pg_ctl.mo /usr/share/locale/fr/LC_MESSAGES/pg_dump.mo /usr/share/locale/fr/LC_MESSAGES/pgscripts.mo /usr/share/locale/fr/LC_MESSAGES/psql.mo /usr/share/locale/hr/LC_MESSAGES/libpq.mo /usr/share/locale/hu/LC_MESSAGES/psql.mo /usr/share/locale/it/LC_MESSAGES/initdb.mo /usr/share/locale/it/LC_MESSAGES/libpq.mo /usr/share/locale/it/LC_MESSAGES/pg_dump.mo /usr/share/locale/it/LC_MESSAGES/pgscripts.mo /usr/share/locale/it/LC_MESSAGES/psql.mo /usr/share/locale/ko/LC_MESSAGES/initdb.mo /usr/share/locale/ko/LC_MESSAGES/libpq.mo /usr/share/locale/ko/LC_MESSAGES/pg_config.mo /usr/share/locale/ko/LC_MESSAGES/pg_ctl.mo /usr/share/locale/ko/LC_MESSAGES/pg_dump.mo /usr/share/locale/ko/LC_MESSAGES/pgscripts.mo /usr/share/locale/ko/LC_MESSAGES/psql.mo /usr/share/locale/nb/LC_MESSAGES/libpq.mo /usr/share/locale/nb/LC_MESSAGES/pg_config.mo /usr/share/locale/nb/LC_MESSAGES/pg_dump.mo /usr/share/locale/nb/LC_MESSAGES/psql.mo /usr/share/locale/pl/LC_MESSAGES/initdb.mo /usr/share/locale/pl/LC_MESSAGES/libpq.mo /usr/share/locale/pl/LC_MESSAGES/pg_config.mo /usr/share/locale/pt_BR/LC_MESSAGES/initdb.mo /usr/share/locale/pt_BR/LC_MESSAGES/libpq.mo /usr/share/locale/pt_BR/LC_MESSAGES/pg_config.mo /usr/share/locale/pt_BR/LC_MESSAGES/pg_ctl.mo /usr/share/locale/pt_BR/LC_MESSAGES/pg_dump.mo /usr/share/locale/pt_BR/LC_MESSAGES/pgscripts.mo /usr/share/locale/pt_BR/LC_MESSAGES/psql.mo /usr/share/locale/ro/LC_MESSAGES/initdb.mo /usr/share/locale/ro/LC_MESSAGES/pg_config.mo /usr/share/locale/ro/LC_MESSAGES/pg_ctl.mo /usr/share/locale/ro/LC_MESSAGES/pg_dump.mo /usr/share/locale/ro/LC_MESSAGES/pgscripts.mo /usr/share/locale/ro/LC_MESSAGES/psql.mo /usr/share/locale/ru/LC_MESSAGES/initdb.mo /usr/share/locale/ru/LC_MESSAGES/libpq.mo /usr/share/locale/ru/LC_MESSAGES/pg_config.mo /usr/share/locale/ru/LC_MESSAGES/pg_ctl.mo /usr/share/locale/ru/LC_MESSAGES/pg_dump.mo /usr/share/locale/ru/LC_MESSAGES/pgscripts.mo /usr/share/locale/ru/LC_MESSAGES/psql.mo /usr/share/locale/sk/LC_MESSAGES/initdb.mo /usr/share/locale/sk/LC_MESSAGES/libpq.mo /usr/share/locale/sk/LC_MESSAGES/pg_ctl.mo /usr/share/locale/sk/LC_MESSAGES/pg_dump.mo /usr/share/locale/sk/LC_MESSAGES/pgscripts.mo /usr/share/locale/sk/LC_MESSAGES/psql.mo /usr/share/locale/sl/LC_MESSAGES/initdb.mo /usr/share/locale/sl/LC_MESSAGES/libpq.mo /usr/share/locale/sl/LC_MESSAGES/pg_config.mo /usr/share/locale/sl/LC_MESSAGES/pg_ctl.mo /usr/share/locale/sl/LC_MESSAGES/pg_dump.mo /usr/share/locale/sl/LC_MESSAGES/pgscripts.mo /usr/share/locale/sl/LC_MESSAGES/psql.mo /usr/share/locale/sv/LC_MESSAGES/initdb.mo /usr/share/locale/sv/LC_MESSAGES/libpq.mo /usr/share/locale/sv/LC_MESSAGES/pg_config.mo /usr/share/locale/sv/LC_MESSAGES/pg_ctl.mo /usr/share/locale/sv/LC_MESSAGES/pg_dump.mo /usr/share/locale/sv/LC_MESSAGES/pgscripts.mo /usr/share/locale/sv/LC_MESSAGES/psql.mo /usr/share/locale/tr/LC_MESSAGES/initdb.mo /usr/share/locale/tr/LC_MESSAGES/libpq.mo /usr/share/locale/tr/LC_MESSAGES/pg_config.mo /usr/share/locale/tr/LC_MESSAGES/pg_ctl.mo /usr/share/locale/tr/LC_MESSAGES/pg_dump.mo /usr/share/locale/tr/LC_MESSAGES/pgscripts.mo /usr/share/locale/tr/LC_MESSAGES/psql.mo /usr/share/locale/zh_CN/LC_MESSAGES/initdb.mo /usr/share/locale/zh_CN/LC_MESSAGES/libpq.mo /usr/share/locale/zh_CN/LC_MESSAGES/pg_config.mo /usr/share/locale/zh_CN/LC_MESSAGES/pg_ctl.mo /usr/share/locale/zh_CN/LC_MESSAGES/pg_dump.mo /usr/share/locale/zh_CN/LC_MESSAGES/pgscripts.mo /usr/share/locale/zh_CN/LC_MESSAGES/psql.mo /usr/share/locale/zh_TW/LC_MESSAGES/initdb.mo /usr/share/locale/zh_TW/LC_MESSAGES/libpq.mo /usr/share/locale/zh_TW/LC_MESSAGES/pg_config.mo /usr/share/locale/zh_TW/LC_MESSAGES/pg_ctl.mo /usr/share/locale/zh_TW/LC_MESSAGES/pg_dump.mo /usr/share/locale/zh_TW/LC_MESSAGES/pgscripts.mo /usr/share/locale/zh_TW/LC_MESSAGES/psql.mo /usr/share/man/man1/clusterdb.1.bz2 /usr/share/man/man1/createdb.1.bz2 /usr/share/man/man1/createlang.1.bz2 /usr/share/man/man1/createuser.1.bz2 /usr/share/man/man1/dropdb.1.bz2 /usr/share/man/man1/droplang.1.bz2 /usr/share/man/man1/dropuser.1.bz2 /usr/share/man/man1/pg_dump.1.bz2 /usr/share/man/man1/pg_dumpall.1.bz2 /usr/share/man/man1/pg_restore.1.bz2 /usr/share/man/man1/psql.1.bz2 /usr/share/man/man1/reindexdb.1.bz2 /usr/share/man/man1/vacuumdb.1.bz2 /usr/share/man/man7/abort.7.bz2 /usr/share/man/man7/alter_aggregate.7.bz2 /usr/share/man/man7/alter_conversion.7.bz2 /usr/share/man/man7/alter_database.7.bz2 /usr/share/man/man7/alter_domain.7.bz2 /usr/share/man/man7/alter_function.7.bz2 /usr/share/man/man7/alter_group.7.bz2 /usr/share/man/man7/alter_index.7.bz2 /usr/share/man/man7/alter_language.7.bz2 /usr/share/man/man7/alter_operator.7.bz2 /usr/share/man/man7/alter_operator_class.7.bz2 /usr/share/man/man7/alter_role.7.bz2 /usr/share/man/man7/alter_schema.7.bz2 /usr/share/man/man7/alter_sequence.7.bz2 /usr/share/man/man7/alter_table.7.bz2 /usr/share/man/man7/alter_tablespace.7.bz2 /usr/share/man/man7/alter_trigger.7.bz2 /usr/share/man/man7/alter_type.7.bz2 /usr/share/man/man7/alter_user.7.bz2 /usr/share/man/man7/analyze.7.bz2 /usr/share/man/man7/begin.7.bz2 /usr/share/man/man7/checkpoint.7.bz2 /usr/share/man/man7/close.7.bz2 /usr/share/man/man7/cluster.7.bz2 /usr/share/man/man7/comment.7.bz2 /usr/share/man/man7/commit.7.bz2 /usr/share/man/man7/commit_prepared.7.bz2 /usr/share/man/man7/copy.7.bz2 /usr/share/man/man7/create_aggregate.7.bz2 /usr/share/man/man7/create_cast.7.bz2 /usr/share/man/man7/create_constraint_trigger.7.bz2 /usr/share/man/man7/create_conversion.7.bz2 /usr/share/man/man7/create_database.7.bz2 /usr/share/man/man7/create_domain.7.bz2 /usr/share/man/man7/create_function.7.bz2 /usr/share/man/man7/create_group.7.bz2 /usr/share/man/man7/create_index.7.bz2 /usr/share/man/man7/create_language.7.bz2 /usr/share/man/man7/create_operator.7.bz2 /usr/share/man/man7/create_operator_class.7.bz2 /usr/share/man/man7/create_role.7.bz2 /usr/share/man/man7/create_rule.7.bz2 /usr/share/man/man7/create_schema.7.bz2 /usr/share/man/man7/create_sequence.7.bz2 /usr/share/man/man7/create_table.7.bz2 /usr/share/man/man7/create_table_as.7.bz2 /usr/share/man/man7/create_tablespace.7.bz2 /usr/share/man/man7/create_trigger.7.bz2 /usr/share/man/man7/create_type.7.bz2 /usr/share/man/man7/create_user.7.bz2 /usr/share/man/man7/create_view.7.bz2 /usr/share/man/man7/deallocate.7.bz2 /usr/share/man/man7/declare.7.bz2 /usr/share/man/man7/delete.7.bz2 /usr/share/man/man7/drop_aggregate.7.bz2 /usr/share/man/man7/drop_cast.7.bz2 /usr/share/man/man7/drop_conversion.7.bz2 /usr/share/man/man7/drop_database.7.bz2 /usr/share/man/man7/drop_domain.7.bz2 /usr/share/man/man7/drop_function.7.bz2 /usr/share/man/man7/drop_group.7.bz2 /usr/share/man/man7/drop_index.7.bz2 /usr/share/man/man7/drop_language.7.bz2 /usr/share/man/man7/drop_operator.7.bz2 /usr/share/man/man7/drop_operator_class.7.bz2 /usr/share/man/man7/drop_owned.7.bz2 /usr/share/man/man7/drop_role.7.bz2 /usr/share/man/man7/drop_rule.7.bz2 /usr/share/man/man7/drop_schema.7.bz2 /usr/share/man/man7/drop_sequence.7.bz2 /usr/share/man/man7/drop_table.7.bz2 /usr/share/man/man7/drop_tablespace.7.bz2 /usr/share/man/man7/drop_trigger.7.bz2 /usr/share/man/man7/drop_type.7.bz2 /usr/share/man/man7/drop_user.7.bz2 /usr/share/man/man7/drop_view.7.bz2 /usr/share/man/man7/end.7.bz2 /usr/share/man/man7/execute.7.bz2 /usr/share/man/man7/explain.7.bz2 /usr/share/man/man7/fetch.7.bz2 /usr/share/man/man7/grant.7.bz2 /usr/share/man/man7/insert.7.bz2 /usr/share/man/man7/listen.7.bz2 /usr/share/man/man7/load.7.bz2 /usr/share/man/man7/lock.7.bz2 /usr/share/man/man7/move.7.bz2 /usr/share/man/man7/notify.7.bz2 /usr/share/man/man7/prepare.7.bz2 /usr/share/man/man7/prepare_transaction.7.bz2 /usr/share/man/man7/reassign_owned.7.bz2 /usr/share/man/man7/reindex.7.bz2 /usr/share/man/man7/release_savepoint.7.bz2 /usr/share/man/man7/reset.7.bz2 /usr/share/man/man7/revoke.7.bz2 /usr/share/man/man7/rollback.7.bz2 /usr/share/man/man7/rollback_prepared.7.bz2 /usr/share/man/man7/rollback_to_savepoint.7.bz2 /usr/share/man/man7/savepoint.7.bz2 /usr/share/man/man7/select.7.bz2 /usr/share/man/man7/select_into.7.bz2 /usr/share/man/man7/set.7.bz2 /usr/share/man/man7/set_constraints.7.bz2 /usr/share/man/man7/set_role.7.bz2 /usr/share/man/man7/set_session_authorization.7.bz2 /usr/share/man/man7/set_transaction.7.bz2 /usr/share/man/man7/show.7.bz2 /usr/share/man/man7/start_transaction.7.bz2 /usr/share/man/man7/truncate.7.bz2 /usr/share/man/man7/unlisten.7.bz2 /usr/share/man/man7/update.7.bz2 /usr/share/man/man7/vacuum.7.bz2 /usr/share/man/man7/values.7.bz2moc sa v tom teda neorientujem. No ten skript bol taky ja som tam len doplnil
/home/postgres/PostgreSQL/bin//postmaster -D /home/postgres/PGDATApretože tak spúšťam postgresql server z prikazovej riadky. Tak som myslel že by to mohlo fungovať ale nefunguje. Ak Ťa niečo napadne budem moc rád. Predom vďaka :)
/etc/logrotate.d/postgresql /etc/rc.d/init.d/postgresqlpozeral som aj do tohoto a je tam ten skript ale aj v /etc/init.d/postgresql. Skúšal som reštart že či nabehne postgresql ale nič sa nestalo stále nenabieha. 2. neviem ako to spustit parametrom "start" stále mi funguje ked som prihlásený ako uživateľ postgres toto: /home/postgres/PostgreSQL/bin//postmaster -D /home/postgres/PGDATA 3. nenašlo by sa na Teba miso nejaké to gizmo alebo jabber? Predom vďaka za ďalšie nápady :)
Tiskni
Sdílej:
ISSN 1214-1267, (c) 1999-2007 Stickfish s.r.o.