Cov txheej txheem:

Kuv yuav nkag mus rau PostgreSQL database ntawm Mac li cas?
Kuv yuav nkag mus rau PostgreSQL database ntawm Mac li cas?

Video: Kuv yuav nkag mus rau PostgreSQL database ntawm Mac li cas?

Video: Kuv yuav nkag mus rau PostgreSQL database ntawm Mac li cas?
Video: Qhia saib seb yus tu hlub комментарий thiab nias like rau leej twg 2021 2024, Kaum ib hlis
Anonim

V. Summary

  1. Nruab PostgreSQL server ntawm MacOSX siv Homebrew.
  2. Siv cov Postgres hais kom ua kab cov cuab yeej rau configure Postgres : Siv cov psql ua command line tool rau saib cov ntaub ntawv hais txog lub database . Tsim tus neeg siv tshiab siv psql ua thiab tsim siv. Hloov tus neeg siv tus password. Tsim ib database siv psql ua thiab tsimb.

Kuj kom paub yog, Kuv yuav pib PostgreSQL ntawm Mac li cas?

29 Teb

  1. Pib manually: pg_ctl -D /usr/local/var/postgres pib.
  2. Nres manually: pg_ctl -D /usr/local/var/postgres nres.
  3. Pib pib: "Yuav kom tau pib pib postgresql tam sim no thiab rov pib dua ntawm tus ID nkag mus:"
  4. Kev ntxuav tu. Postgres feem ntau yuav raug ntsia ntawm Homebrew, Fink, MacPorts lossis EnterpriseDB installer.

Kuj Paub, PostgreSQL nyob qhov twg ntawm Mac? Qhov System: MAC OS X 10.9. 9.4) qhov no yog nyob rau hauv dir hu ua /Library/ PostgreSQL Yog tias koj mus qhov ntawd, qhib lub nplaub tshev npe hu ua ver. ntawm koj PG thiab tom qab ntawd mus rau cov ntaub ntawv folder koj yuav nrhiav koj db.

Ntawm no, kuv yuav txuas mus rau PostgreSQL database li cas?

Txuas rau PostgreSQL database server siv psql ua Ua ntej, tso tawm psql ua program thiab txuas mus rau PostgreSQL Database Server siv lub postgres tus neeg siv los ntawm nias lub psql ua icon raws li qhia hauv qab no: Thib ob, nkag mus rau cov ntaub ntawv tsim nyog xws li Server, Database , Chaw nres nkoj, Username, thiab Password. Nyem Enter kom lees txais lub neej ntawd.

PostgreSQL database khaws cia nyob qhov twg?

Cov PostgreSQL database server configuration file yog postgresql ua . conf ua. Cov ntaub ntawv no nyob rau hauv lub cov ntaub ntawv directory ntawm tus neeg rau zaub mov, feem ntau /var/lib/ postgres / cov ntaub ntawv . Cov ntawv tais ceev no tseem nyob hauv lwm cov ntaub ntawv tseem ceeb, suav nrog pg_hba.

Pom zoo: