Dotaz: Ako schému outcafe.sql dostať do postgrepSQL?

[Diabloo]

Dobrý deň, môj problém pozostáva z toho, že potrebujem nainštalovať outcafe , ktoré požaduje postrgreSQL server. Tento sa mi podarilo rozchodit no a ďalší krok by malo byť toto:

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.

Odpovědi

[miso]

psql meno_databazy < outcafe.sql

[cronin]

A pri pripadnych problemoch najskor pouzit man psql a Google, nie abclinuxu.cz.

[Diabloo]

Vďaka presne to som potreboval. Už sa v tom špáram asi 3 dni tak som rád, že mi niekto poradil normálne a nie google :) Ešte raz vďaka.

[miso]

Nechcem sa posmievat, ale co si preboha tie 3 dni robil?

[Diabloo]

Tak aby som ťa dostal do obrazu. V živote som neštudoval informatiku(ak neberiem do úvahy na VŠ, kde sme sa učili písať vo Worde, trošku Excel) ja som študoval ekonómiu, a Linux je môj koníček, a chcel by som si s ním čo najviac porozumieť. Takže sorry, že neviem programovať, neviem ako to všetko funguje. Ale všetko čo viem som sa naučil sám, s pomocou literatúry na webe a s pomocou dobrých ľudí na tomto fóre.

Tak dúfam, že som Ti trošku objasnil moju situáciu

S pozdravom :)

[miso]

Ale ja sa neposmievam ani nic podobne (ten smajlik by to mal vysvetlovat),
inac by som Ti v prvom prispevku nepisal odpoved
takze take it easy

[Diabloo]

No ved ja som nevravel že sa vysmievaš... len som chcel aby si vedel v akej som situácii. :) Ono nie každý kto navštevuje túto stránku je odborník... len to som tým chcel povedať. A ten návod mi pomohol a som Ťi zaň vďačný :):):)

[Diabloo]

hups chybka: Ťi=Ti :):):)

[Diabloo]

Mal by som ešte jednu otázočku, už sa mi podarilo spustit Outcafe pomocou ktorého vytváram užívateľov atď, ktorý sa zapisujú do databázy. No ale problém je v tom, že keď ráno spúšťam server tak musím ručne:

su - postgres        (kedze som prihlásený ako uživateľ server)
/home/postgres/PostgreSQL/bin/postmaster -D /home/postgres/PGDATA

a 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

#!/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

potom

chmod +x /etc/rc.local

ale nepomohlo to. Neviete kde by sa to dalo nastavit? Predom vďaka za odpovede.

[miso]

Ten skript nevyzera dobre. To v mandrive (pouzivas mandrivu, ano?) tento skript nie je zabaleny?
Skus pozriet zoznam suborov rpm -ql postgresql

[Diabloo]

Ano je to mandriva 2007.1 Hodil som ten prikaz a toto je vysledok:

[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.bz2

moc sa v tom teda neorientujem. No ten skript bol taky ja som tam len doplnil

/home/postgres/PostgreSQL/bin//postmaster -D /home/postgres/PGDATA

pretož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 :)

[miso]

Ehm, sorry, malo to byt rpm -ql postgresql-server (pisal som to len tak z hlavy) a to skus porovnat s tymto - v tomto pripade je /etc/init.d/postgresql startovaci skript (spusta sa parametrom "start" alebo "stop", pripadne "status" vypise, ci prave bezi alebo nebezi)

[Diabloo]

takže 1. balík postgresql-server som ani nemal nainštalovaný.....tak som ho doinštaloval a ten výpis mi píše skoro to isté ako v tom príklade až na pár drobností (myslím že nepodstatných) ale prvé dva riadky sú iné a to:

/etc/logrotate.d/postgresql
/etc/rc.d/init.d/postgresql

pozeral 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 :)

[miso]

1 - ano, ten druhy skript je ten spravny
2 - jabber mam v profile, staci kliknut na moj nick