Tag Info

New answers tagged

1

there is another way to reduce your bloat space when you can remove tuples in heap pages, this method use less adding space to reduce your bloat table. LIKE exp : pg93@db-172-16-3-150-> psql psql (9.3.3) Type "help" for help. digoal=# create table t_bloat(id int primary key, info text, crt_time timestamp); CREATE TABLE digoal=# insert into t_bloat ...


1

If your environment has disk space more than this table's "real data(after reduced)" size. you can use pg_reorg reduce this table's bloat space. or you can use londiste3 increment copy this table, and use less time to exchange. but if your env has no more space than this table, you can't reduce.


3

If you use anything but CLUSTER / VACUUM FULL / pg_repack you need to make sure there are no concurrent writes to the table. Take an exclusive lock on the table and do everything in a single transaction or, better yet, shut out all connections to avoid concurrent changes. TABLESPACE Yes, your last idea could work. Create a new tablespace on the other disk. ...


1

We hit the same problem on deploying 5.6 as part of our standards we always install from .rpm and relocate the data dir after the first set up . 5.5 and lower we would change our settings in the /etc/my.cnf stop mysql and then tar up the database directories in the default data dir and untar to our new one . As we change all our innodb settings we then got ...


7

This answer applies to modifying the PostgreSQL source code by applying a "diff" or "patch". It's not about installing minor version updates; to do that, just download and run the installer. To alter the PostgreSQL server its self or its procedural language runtimes, you will generally need to recompile PostgreSQL from scratch. On Windows that's a bit of ...


1

For that purpose you can download the pre-built virtual Machines (VMs) provided by Oracle. They only need Oracle Virtual Box in order to check them out (https://www.virtualbox.org/wiki/Downloads). You can download them here: http://www.oracle.com/technetwork/community/developer-vm/index.html This is the best solution for learning Oracle DB, without ...


0

Your Windows 7 PC supports IPv6 natively. I'd say your pg_hba.conf is set to require md5 on connections from ::1 but not on 127.0.0.1. This works on your XP machines because they won't connect over IPv6. On Win 7, they'll happily use IPv6 (and PuTTY will happily tunnel IPv6), so they probably appear to have the origin address of ::1. To confirm if this is ...


0

You need to create the root user with a password SET sql_log_bin = 0; GRANT ALL ON *.* to root@'%' IDENTIFIED WITH 'rootpass' WITH GRANT OPTION; I would make it a little more secure. Perhaps by doing the following: use a username other than root (like remote_user) instead of %, user the netblock of the IP of PC2 (such as 10.20.30.%) Therefore, you run ...


1

You most likely need to set the ORACLE_SID environment variable. This error usually means you are trying to connect to a database that doesn't exist. Also check that ORACLE_HOME is set correctly. If that doesn't fix it, check if the database service is started. If it is, check the alert log for error messages.


1

This is so funny. Yesterday, someone asked how to do the opposite and I answered that question : Migrate from innodb_file_per_table to off in MySQL Here the steps for what you want STEP #1 Set innodb_file_per_table to 0 in my.ini [mysqld] innodb_file_per_table = 1 STEP #2 Login in Command Prompt in Administrator mode and run C:\> net stop mysql ...



Top 50 recent answers are included