PostgreSQL 9.13

I always wanted to make some contributions to PostgreSQL. Today I am free, so I wrote a tutorial on getting started with PostgreSQL 9.13...

On deployment, you can move here...

PHP 5.4.10 + Nginx 1.0.12 + PostgreSQL 9.1.3 source code compilation automated deployment of Version 2

Bytes -----------------------------------------------------------------------------------------

| System | CentOS 5.7.

Bytes -----------------------------------------------------------------------------------------

| Db| PostgreSQL 9.13

Bytes -----------------------------------------------------------------------------------------

Some initialization work has been done in the lnpp script, for example:

1. Su postgres-c "$ PG_ROOT/bin/initdb-D $ PG_ROOT/data & exit"

Enter some data for later query.

1. -- Database: bpsimple
4. -- Drop database bpsimple;
7. CREATE DATABASEBpsimple
8. WITHOWNER = ipvs
9. ENCODING ='Utf8'
10. TABLESPACE = pg_default
11. LC_COLLATE ='En _ US.UTF-8'
12. LC_CTYPE ='En _ US.UTF-8'
13. CONNECTIONLIMIT =-1;
14. <PreName="Code"Class ="SQL">-- Table: item
15. -- Drop table item;
17. CREATE TABLEItem
18. (
19. Item_id serialNOT NULL,
20. DescriptionCharacter Varying(64)NOT NULL,
21. Cost_priceNumeric(7,2 ),
22. Sell_priceNumeric(7,2 ),
23. CONSTRAINTItem_pkPRIMARY KEY(Item_id)
24. )
25. WITH(
26. OIDS =FALSE
27. );
28. ALTER TABLEItem
29. OWNERTONeil;

I copied the above SQL pane directly from pgadmin 3, which is the existing data on my simulator, so the above statements have not been tested!

If there is a problem with the http://www.postgresql.org/docs/9.1/interactive/index.html, you can have a manual!

Next, we need to configure postgresql for external access...

Access authorization first...

# Vim $ PG_ROOT/data/pg_hda.conf

Host bpsimple neil all trust

# Vim postgresql. conf

Listen_addresses = '*'

Port = 5432

After setting the listening port, restart postgresql...

Su $ PGUSER-c "$ PGCTL stop-d' $ pgdata'-m fast"

Su $ PGUSER-c "$ PGDAEMON-D '$ pgdata' &" >>$ PGLOG 2> & 1

The specific environment variables depend on different hosts. Well, the topic starts. First, write a pg class...

# Vim./pgphp/dbconn. php

1. <? Php
3. Class dbconn {
5. Private $ linkid; // PostgreSQL link identifier
6. Private $ host; // PostgreSQL server host
7. Private $ db; // PostgreSQL database
8. Private $ user; // PostgreSQL user
9. Private $ passwd; // PostgreSQL password
10. Private $ result; // Query result
11. Private $ querycount; // Total queries excuted
13. /* Class constructor. Initializes the $ host, $ user, $ passwd
14. And $ db fields .*/
16. Function _ construct ($ host, $ db, $ user, $ passwd ){
17. $ This-> host = $ host;
18. $ This-> user = $ user;
19. $ This-> passwd = $ passwd;
20. $ This-> db = $ db;
21. }
23. /* Connects to the PostgreSQL Database */
25. Function connect (){
26. Try {
27. $ This-> linkid = @ pg_connect ("host = $ this-> host dbname = $ this-> db
28. User = $ this-> user password = $ this-> passwd ");
29. If (! $ This-> linkid)
30. Throw new Exception ("cocould not connect to PostgreSQL server .");
31. } Catch (Exception $ e ){
32. Die ($ e-> getMessage ());
33. }
34. }
36. /* Execute database query .*/
38. Function query ($ query ){
39. Try {
40. $ This-> result = @ pg_query ($ this-> linkid, $ query );
41. If (! $ This-> result)
42. Throw new Exception ("The database query failed .");
43. } Catch (Exception $ e ){
44. Echo $ e-> getMessage ();
45. }
46. $ This-> querycount ++;
47. Return $ this-> result;
48. }
50. /* Determine total rows affected by query .*/
52. Function affectedRows (){
53. $ Count = @ pg_affected_rows ($ this-> linkid );
54. Return $ count;
55. }
57. /* Determine total rows returned by query */
59. Function numRows (){
60. $ Count = @ pg_num_rows ($ this-> result );
61. Return $ count;
62. }
64. /* Return query result row as an object .*/
66. Function fetchObject (){
67. $ Row = @ pg_fetch_object ($ this-> result );
68. Return $ row;
69. }
71. /* Return query result row as an indexed array .*/
73. Function fetchRow (){
74. $ Row = @ pg_fetch_row ($ this-> result );
75. Return $ row;
76. }
78. /* Return query result row as an associated array .*/
80. Function fetchArray (){
81. $ Row = @ pg_fetch_array ($ this-> result );
82. Return $ row;
83. }
85. /* Return total number of queries executed
86. Lifetime of this object. Not required,
87. Interesting nonetheless .*/
89. Function numQueries (){
90. Return $ this-> querycount;
91. }
93. }
94. ?>

1 2 Next Page