- Timestamp:
- 10/02/2016 10:14:17 PM (8 years ago)
- Branches:
- 10.0, 10.1, 11.0, 11.1, 11.2, 11.3, 12.0, 12.1, 8.0, 8.1, 8.2, 8.3, 8.4, 9.0, 9.1, basic, bdubbs/svn, elogind, kea, ken/TL2024, ken/inkscape-core-mods, ken/tuningfonts, lazarus, lxqt, nosym, perl-modules, plabs/newcss, plabs/python-mods, python3.11, qt5new, rahul/power-profiles-daemon, renodr/vulkan-addition, trunk, upgradedb, xry111/intltool, xry111/llvm18, xry111/soup3, xry111/test-20220226, xry111/xf86-video-removal
- Children:
- 917fa4d2
- Parents:
- 128b5380
- Location:
- server/databases
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
server/databases/mariadb.xml
r128b5380 rfcafd3d 10 10 <!ENTITY mariadb-download-http " "> 11 11 <!ENTITY mariadb-download-ftp "ftp://mirrors.fe.up.pt/pub/mariadb/mariadb-&mariadb-version;/source/mariadb-&mariadb-version;.tar.gz"> 12 <!ENTITY mariadb-md5sum " 036aca95257cb2948dd100605ec6d5a1">12 <!ENTITY mariadb-md5sum "173b88ab54bdd1fc51483b6b26bef849"> 13 13 <!ENTITY mariadb-size "58 MB"> 14 14 <!ENTITY mariadb-buildsize "1.2 GB (with tests)"> -
server/databases/postgresql.xml
r128b5380 rfcafd3d 7 7 <!ENTITY postgresql-download-http "http://ftp.postgresql.org/pub/source/v&postgresql-version;/postgresql-&postgresql-version;.tar.bz2"> 8 8 <!ENTITY postgresql-download-ftp "ftp://ftp.postgresql.org/pub/source/v&postgresql-version;/postgresql-&postgresql-version;.tar.bz2"> 9 <!ENTITY postgresql-md5sum " ad36fcf624748b8ed67783ad04529f43">9 <!ENTITY postgresql-md5sum "c5af6ebb790ab877e1d2e56e19cebb29"> 10 10 <!ENTITY postgresql-size "18 MB"> 11 <!ENTITY postgresql-buildsize " 238MB (with tests)">11 <!ENTITY postgresql-buildsize "197 MB (with tests)"> 12 12 <!ENTITY postgresql-time "1.8 SBU (with tests)"> 13 13 ]> … … 143 143 <screen role="root"><userinput>install -v -dm700 /srv/pgsql/data && 144 144 install -v -dm755 /run/postgresql && 145 145 146 groupadd -g 41 postgres && 146 147 useradd -c "PostgreSQL Server" -g postgres -d /srv/pgsql/data \ 147 148 -u 41 postgres && 148 chown -Rv postgres:postgres /srv/pgsql /run/postgresql && 149 su - postgres -c '/usr/bin/initdb -D /srv/pgsql/data'</userinput></screen> 150 151 <para>As the <systemitem class="username">root</systemitem> user, start the 152 database server with the following command:</para> 149 150 chown -Rv postgres:postgres /srv/pgsql /run/postgresql</userinput></screen> 151 152 <para>Now, initialize the database at the <systemitem 153 class="username">root</systemitem> user:</para> 154 155 <screen role="root"><userinput>su - postgreo -c '/usr/bin/initdb -D /srv/pgsql/data'</userinput></screen> 156 157 <para>Again as the <systemitem class="username">root</systemitem> user, 158 start the database server with the following command:</para> 153 159 154 160 <screen role="root"><userinput>su - postgres -c '/usr/bin/postgres -D /srv/pgsql/data > \ … … 168 174 | (su - postgres -c '/usr/bin/psql test ') && 169 175 echo "select * from t1;" | (su - postgres -c '/usr/bin/psql test')</userinput></screen> 176 177 <para>To shut down the server, as <systemitem 178 class="username">root</systemitem>:</para> 179 180 <screen role="root"><userinput>su - postgres -c "/usr/bin/pg_ctl stop -D /srv/pgsql/data"</userinput></screen> 170 181 171 182 </sect2>
Note:
See TracChangeset
for help on using the changeset viewer.