From: "Александр Глухов" <alexandrgluhov@mail.ru>
To: buildroot@busybox.net
Subject: [Buildroot] postgreSQL in buildroot
Date: Wed, 29 Oct 2014 15:46:04 +0300 [thread overview]
Message-ID: <1414586764.228504684@f411.i.mail.ru> (raw)
Hello, I'm using Buildroot for building Linux on my one-boarded computer on the base of freescale i.mx28. And I select postgresql in make menuconfig window. Now I want to configure postgresql, I mean, I want to set database destination, name, username and password, port and create tables in database but I don't know how to do it. And I have not enough experience in it. I tried search config files and tried run initdb and createdb on i.mx28, but unsuccessfully. When I run the i.mx, I get the following messages:
?
Initializing postgresql data base...
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
?
?
The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".
?
?
Data page checksums are disabled.
?
?
fixing permissions on existing directory /var/lib/pgsql ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 64MB
creating configuration files ... ok
creating template1 database in /var/lib/pgsql/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating collations ... sh: locale: not found
ok
No usable system locales were found.
Use the option "--debug" to see details.
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
loading PL/pgSQL server-side language ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok
syncing data to disk ... ok
?
?
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
?
?
Success. You can now start the database server using:
?
?
??? /usr/bin/postgres -D /var/lib/pgsql
or
??? /usr/bin/pg_ctl -D /var/lib/pgsql -l logfile start
?
?
done
Starting postgresql: server starting
OK
?
So, it seems, that postgreSQL works, and create database template with user postgres.
I already read documentation, but I still have this problem.
So, could you help me, or advise something, because I have not enough experience to do it by myself.?
With best regards,
Alexandr Glukhov
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.busybox.net/pipermail/buildroot/attachments/20141029/c6b9c2d0/attachment.html>
next reply other threads:[~2014-10-29 12:46 UTC|newest]
Thread overview: 3+ messages / expand[flat|nested] mbox.gz Atom feed top
2014-10-29 12:46 Александр Глухов [this message]
2014-10-30 8:19 ` [Buildroot] postgreSQL in buildroot Arnout Vandecappelle
2014-10-30 8:26 ` Arnout Vandecappelle
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=1414586764.228504684@f411.i.mail.ru \
--to=alexandrgluhov@mail.ru \
--cc=buildroot@busybox.net \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox