rds postgres

PGXL Cluster ConstructionA preparation1 Download Install decompression source/opt/Curl-o http://files.postgres-xl.org/postgres-xl95r1beta1.tar.gzTAR-ZXVF postgres-xl95r1beta1.tar.gzMV Postgres-xl95r1beta1.tar.gz POSTGRES-XL2 compiling$ yum-y gcc$ CD POSTGRES-XL$ pwd/opt/

Front-facing conditionsTo achieve the purpose: to develop the local computer needs to connect with no network address of the RDS, through the ECS forwarding connection to the RDS databaseClient PC terminal can SSH login to the ECS server with public network.ECS servers with a public network can access other intranet ECS servers through the intranet.ECS Server with public network can access

1. Prepare Create a base table first: CREATE TABLE mytb1 (ID serial,name character varying,age integer);To create an index on the name field: Create INDEX Mytb1_name_index on MYTB1 (name); To view the MYTB1 table structure: postgres=# \d mytb1; Table "public.mytb1" Column | Type | Modifiers --------+-------------------+--------------------------------------------

Release date: 2011-12-13Updated on: 2011-12-14 Affected Systems:Adobe ColdFusion 9.0.1Adobe ColdFusion 9.0Adobe ColdFusion 8.0.1Adobe ColdFusion 8.0Description:--------------------------------------------------------------------------------Bugtraq id: 51043Cve id: CVE-2011-4368 Adobe ColdFusion is a dynamic Web server. Adobe ColdFusion has a cross-site scripting vulnerability in the implementation of RDS. Attackers can exploit this vulnerability to

1. Choose a good installation version based on RDS 2 Uninstall the original database Rpm-qa | grep MySQL Run the command on the next line based on the results of the above query Rpm-ev--nodeps XXXXX Yum Remove Mysql-server mysql-devel rm–rf/usr/my.cnf Rm-rf/root/.mysql_sercret Rm-rf/etc/my.cnf Rm-rf/var/lib/mysql 3 Download installation package wget http://dev.mysql.com/Downloads/MySQL-5.6/MySQL-server-5.6.21-1.rhel5.x86_64.rpm wget http://dev.mysql.c

Test_print_report.asp Client use RDS produce Excel

1. AWS Query Slow LogSelect COUNT (1), user_host from Mysql.slow_log Group by User_host;Select COUNT (*) from Mysql.slow_log;mysql> desc Mysql.slow_log;+----------------+---------------------+------+-----+-------------------+-----------------------------+| Field | Type | Null | Key | Default | Extra |+----------------+---------------------+------+-----+-------------------+-----------------------------+| start_time | Timestamp | NO | | Current_timestamp | On Update Current_timestamp || User_host

Problem Description:Using mysqlbinlog-vv mysql-bin.000110 to view the RDS MySQL binaries found similar to the following results:‘ MgI+UA8BAAAAZwAAAGsAAAAAAAQANS41LjI1LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAyAj5QEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA== ‘/*!*/; As shown in the following:Workaround:The marked part is not garbled, but through Base64 encoding results, you can view the Binlog log by Mysqlbinlog to add parameters to decod

Postgres uses returning to implement last_insert_id of mysql. Today, I am asked if postgres has inserted a value like mysql and returned the inserted value. This is yes and has higher scalability. Example: [S @ localhost ~] $ Psqlpsql (9.2.4) Typehelpforhelp. S # createtable Postgres uses returning to implement last_insert_id of mysql. Today, I am asked if

Psql: Fatal error: User "Postgres" Ident authentication failed1 after installing the PostgreSQL database, you need to initialize and some configuration rails project to connect PostgreSQL.After the PostgreSQL data is installed (the Yum command is installed directly)First step: Initialize the database#service PostgreSQL Initdb(Description: After initialization the default PostgreSQL database has a default user post