search for: initdb

Hi, Anybody have success with postgresql 8.1.3 on a new Intel OS X box? All hints welcome, please! I installed postgres 8.1.3 via darwinports, and everything is great until the initdb step. Initdb fails on shmget saying it couldn''t allocate enough memory (see below). So, I edited /etc/rc and increased kern.sysv.shmmax from 4194304 to 41943040 (4MB to 40MB) After reboot and attempt to initdb, I get the same error. Thanks, John jdell@xyz->sudo su postgres8 -c &...

...base via a shell script. cwd changes the working directory to the module''s destination, and the initializePostgres shell script is executed as user postgres (belonging to group postgres). The puppet agents OS has a user postgres belonging to group postgres. The shell script contains an initdb command that initializes a postgres PGDATA directory, and both have the following permissions: [root@host]# ls -al initializePostgres.sh -rwxr-x---. 1 postgres postgres 2231 Mar 14 18:04 initializePostgres.sh [root@host]# ls -ald data drwxr-xr-x. 2 postgres postgres 4096 Mar 18 17:34 data When...

...to the path at samba_share_t on /mnt/data. After this samba works. Now I'm setting up postgresql on the same machine, and for first disk size I must use /dev/md2. After configuring postgresql script to init the db, and setting up the alternative data path pointing to /mnt/data/pgsql/data, initdb or start postgresql fail. This issue is selinux related. Now, directory /mnt/data/pgsql/data, has fcontext to samba_share_t and postgresql init script give permission denied on /mnt/data/pgsql/data/postgresql.conf. At this point I've tried to set with chcon /mnt/data at postgresql_db_t, r...

Hi, I've made mysqlf a RPM and installed it. After that i did what i shouldn' do: remove the files it installed. Now, i wnat to install it agai and i can't. Already rebuilt the rpm database ( rpm -vv --rebuilddb), used --force, --replacepkgs, --replacefiles, --justdb, --erase, --initdb, but no good. Been at rpm.org, but found nothing that i already know. Any help would be appreciated. Warm regards, M?rio Gamito

...imed this: Umm, you should choose an encoding supported by your platform and the locales you use. For example, UTF-8 is a bad choice on *BSD because there is no collation support for UTF-8 on those platforms. On Linux/Glibc UTF-8 is well supported but you need to make sure the locale you initdb with is a UTF-8 locale. By and large postgres correctly autodetects the encoding from the locale. Is this an accurate claim for FreeBSD? I need to have a UTF-8 encoded database in an upcoming project, and performance is always a concern. Thanks.

...um clean all", but that wouldn't complete either. I tried to do a rpm --rebuild, but that failed with a segmentation fault. Tried it a couple of times... Reboot didn't work. I copied the database files out of /var/lib/rpm to a safe location, then deleted the __db.* files. Ran rpm --initdb. That seemed to work. Now, I've been running rpm --rebuild for around 18 hours. The load factor on the server is 1.0, according to uptime. Top shows that it is running, using 100% cpu. Iostat shows around 25% usr load. I see the os raid drives bounce on occasion. ps -ef shows the follow...

...default postgresql install and installed it from the software collections.. following the instructions at https://www.softwarecollections.org/en/scls/rhscl/rh-postgresql95/ and I get this [root at home1p /home/jason]$scl enable rh-postgresql95 bash [root at HOME1P jason]# postgresql-setup --initdb * Initializing database in '/var/opt/rh/rh-postgresql95/lib/pgsql/data' * Initialized, logs are in /var/lib/pgsql/initdb_rh-postgresql95-postgresql.log [root at HOME1P jason]# service rh-postgresql95-postgresql start Starting rh-postgresql95-postgresql service: [ OK ] [...

All of a sudden yum hangs on a Centos 4.5 (updated to the latest patch before 4.6) when I try to use it. "clean metadata" didn't help. The output of -d5 shows it gets to the point of "Reading Local RPMDB" and then sits there. The process doesn't die, but doesn't seem to do anything from that point on. strace shows this: futex(0xb76dcae8, FUTEX_WAIT, 2, NULL I

...wget --quiet https://ltb-project.org/archives/openldap-ltb-2.4.47-1.el7.x86_64.rpm Now, I try to make an RPM database of these packages. The last step fails with an unmet dependency: $ sudo mount ~/CentOS-7-x86_64-Minimal-1810.iso -r -t iso9660 -o loop /mnt $ mkdir -p ~/local_rpm_db $ rpm --initdb --dbpath ~/local_rpm_db $ rpm --justdb --ignoresize --dbpath ~/local_rpm_db -Uvh /mnt/Packages/*.rpm *.rpm warning: /mnt/cdrom/Packages/acl-2.2.51-14.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEY warning: berkeleydb-ltb-4.6.21.NC-4.el7.patch4.x86_64.rpm: Header V4 DSA...

on the old postgresql that comes with centos 6? Ive asked google over and over and he wont tell me. :( (im trying to install it as a requirement for NIPAP) Jason

...nning this, so all my databases are on it sudo yum -y install https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6-x86_64/pgdg-centos95-9.5-3.noarch.rpm sudo yum -y install postgresql95-{server,contrib,devel} # install server and components sudo service postrgresql-9.5 initdb # initialize database cluster sudo service postgresql-9.5 start # start database server sudo chkconfig postgresql-9.5 on # set so db server always runs at boot sudo -u postgres psql -c "create user $USER superuser; create database $USER owner $USER" that last step...

...hree easy steps: $ sudo yum install centos-release-scl $ sudo yum install rh-postgresql95 $ scl enable rh-postgresql95 bash At this point you should be able to use PostgreSQL just as a normal application. Here are some examples of commands you can run: $ postgresql-setup --initdb $ service rh-postgresql95-postgresql start $ su postgres -c psql In order to view the individual components included in this collection, including additional subpackages, you can run: $ sudo yum list rh-postgresql95\* For more on PostgreSQL in general, see http://www.postgresql...

...hree easy steps: $ sudo yum install centos-release-scl $ sudo yum install rh-postgresql95 $ scl enable rh-postgresql95 bash At this point you should be able to use PostgreSQL just as a normal application. Here are some examples of commands you can run: $ postgresql-setup --initdb $ systemctl start rh-postgresql95-postgresql $ su postgres -c psql In order to view the individual components included in this collection, including additional subpackages, you can run: $ sudo yum list rh-postgresql95\* Last but not least you can try this Software Collection in...

I''m trying out migrations for the first time, and I''m having a problem with my sqlite3 db. A trivial example of what I''m seeing: class InitDb < ActiveRecord::Migration def self.up create_table :mytable, :force => true do |t| t.column :lname, :string t.column :created_at, :string, :default => ''CURRENT_TIMESTAMP'' end end def self.down end end When I dump t...

Hello, I would like to start the database server (postgres) before tests are run and stop it afterwards. For this, I have created a little wrapper around rake: $ cat run-rake #! /bin/sh DB=`pwd`/db/pgdata # init database cluster if it does not exist yet [ -d $DB ] || initdb -D$DB # start the database server pg_ctl -D$DB -o "-h '''' -k $DB" -l postgreslog start # wait for it to accept connections sleep 1 # run rake with original arguments rake "$*" # we''re done, stop database server again...

...pdate packages in advance of the upstream vendor and wish to employ postgrsql 8.3 may find this a much more convenient method than manually upgrading and updating via RPM. Note that a pgdump of all existing databases before upgrading, removal of the tablespace in /var/lib/pgsql/data, performing an initdb following the software upgrade and finally a restore from the backup are still (and painfully) required to upgrade from versions older than 8.3.0 Note as well that some the preset configuration values in postgres.conf have changed, that some options have been removed and new ones added so that a d...

Hi guys, Pls I need good and working instructions on how to install phpmyadmin on centos 6.3 ? I would appreciate your kind and timely response on this. regards kunle

...ed in three easy steps: $ sudo yum install centos-release-scl $ sudo yum install rh-postgresql96 $ scl enable rh-postgresql96 bash At this point you should be able to use PostgreSQL just as a normal application. Here are some examples of commands you can run: $ postgresql-setup --initdb $ service rh-postgresql96-postgresql start $ psql In order to view the individual components included in this collection, including additional subpackages, you can run: $ sudo yum list rh-postgresql96\* This collections is CentOS-based rebuild built by SCLo SIG community, and the pac...

...nstall the collection: $ sudo yum install rh-postgresql10 # 3. Start using software collections: $ scl enable rh-postgresql10 bash At this point you should be able to use PostgreSQL just as a normal application. Here are some examples of commands you can run: $ postgresql-setup --initdb $ service rh-postgresql10-postgresql start $ psql This collections is CentOS-based rebuild built by SCLo SIG community, and the packages have been available in Red Hat Software Collections 3.1 for RHEL: https://access.redhat.com/documentation/en-us/red_hat_software_collections/3/html/3.1...

...ed in three easy steps: $ sudo yum install centos-release-scl $ sudo yum install rh-postgresql96 $ scl enable rh-postgresql96 bash At this point you should be able to use PostgreSQL just as a normal application. Here are some examples of commands you can run: $ postgresql-setup --initdb $ service rh-postgresql96-postgresql start $ psql In order to view the individual components included in this collection, including additional subpackages, you can run: $ sudo yum list rh-postgresql96\* Last but not least you can try this Software Collection in Docker. You can pull t...