I. 教程
II. SQL 语言
III. 服务器管理
- 章14. 安装指导
- 章15. 在 Windows 上安装客户端
- 章16. 操作系统环境
- 章17. 服务器配置
- 章18. 数据库角色和权限
- 章19. 管理数据库
- 章21. 区域
- 章20. 用户认证
- 章22. 日常数据库维护工作
- 章23. 备份与恢复
- 章24. 高可用性与负载均衡
- 章25. 监控数据库的活动
- 章26. 监控磁盘使用情况
- 章27. 可靠性和预写式日志
- 章28. 回归测试
IV. 客户端接口
- Chapter 28. libpq - C 库
- 章29.
- Chapter 30. ecpg - 在 C 里嵌入 SQL
- Chapter 31. 信息模式
- 31.2. 数据类型
- 31.3. informationschemacatalog_name
- 31.4. applicable_roles
- 31.5. check_constraints
- 31.6. columndomainusage
- 31.7. column_privileges
- 31.8. columnudtusage
- 31.9. columns
- 31.10. constraintcolumnusage
- 31.11. constrainttableusage
- 31.12. datatypeprivileges
- 31.13. domain_constraints
- 31.14. domainudtusage
- 31.15. domains
- 31.16. element_types
- 31.17. enabled_roles
- 31.18. keycolumnusage
- 31.20. referential_constraints
- 31.21. rolecolumngrants
- 31.22. roleroutinegrants
- 31.23. roletablegrants
- 31.24. roleusagegrants
- 31.25. routine_privileges
- 31.26. routines
- 31.27. schemata
- 31.28. sql_features
- 31.29. sqlimplementationinfo
- 31.30. sql_languages
- 31.31. sql_packages
- 31.32. sql_sizing
- 31.33. sqlsizingprofiles
- 31.34. table_constraints
- 31.35. table_privileges
- 31.36. tables
- 31.37. triggers
- 31.38. usage_privileges
- 31.39. viewcolumnusage
- 31.40. viewtableusage
- 31.41. views
V. 服务器端编程
- 章33. 扩展 SQL
- 章34. 触发器
- 章35. 规则系统
- 章36. 过程语言
- 章37. PL/pgSQL - SQL 过程语言
- 章38. PL/Tcl - Tcl 过程语言
- 章39. PL/Perl - Perl 过程语言
- 章40. PL/Python - Python 过程语言
- 章41. 服务器编程接口
VI. 参考手册
- I. SQL 命令
- ABORT
- ALTER AGGREGATE
- ALTER CONVERSION
- ALTER DATABASE
- ALTER DOMAIN
- ALTER FUNCTION
- ALTER GROUP
- ALTER INDEX
- ALTER LANGUAGE
- ALTER OPERATOR
- ALTER OPERATOR CLASS
- ALTER ROLE
- ALTER SCHEMA
- ALTER SEQUENCE
- ALTER TABLE
- ALTER TABLESPACE
- ALTER TRIGGER
- ALTER TYPE
- ALTER USER
- ANALYZE
- BEGIN
- CHECKPOINT
- CLOSE
- CLUSTER
- COMMENT
- COMMIT PREPARED
- COMMIT
- COPY
- CREATE AGGREGATE
- CREATE CAST
- CREATE CONSTRAINT TRIGGER
- CREATE CONVERSION
- CREATE DATABASE
- CREATE DOMAIN
- CREATE FUNCTION
- CREATE GROUP
- CREATE INDEX
- CREATE LANGUAGE
- CREATE OPERATOR CLASS
- CREATE OPERATOR
- CREATE ROLE
- CREATE RULE
- CREATE SCHEMA
- CREATE SEQUENCE
- CREATE TABLE
- CREATE TABLE AS
- CREATE TABLESPACE
- CREATE TRIGGER
- CREATE TYPE
- CREATE USER
- CREATE VIEW
- DEALLOCATE
- DECLARE
- DELETE
- DROP OWNED
- DROP AGGREGATE
- DROP CAST
- DROP CONVERSION
- DROP DATABASE
- DROP DOMAIN
- DROP FUNCTION
- DROP GROUP
- DROP INDEX
- DROP LANGUAGE
- DROP OPERATOR CLASS
- DROP OPERATOR
- DROP ROLE
- DROP RULE
- DROP SCHEMA
- DROP SEQUENCE
- DROP TABLE
- DROP TABLESPACE
- DROP TRIGGER
- DROP TYPE
- DROP USER
- DROP VIEW
- END
- EXECUTE
- EXPLAIN
- FETCH
- GRANT
- INSERT
- LISTEN
- LOAD
- LOCK
- MOVE
- NOTIFY
- PREPARE TRANSACTION
- PREPARE
- REASSIGN OWNED
- REINDEX
- RELEASE SAVEPOINT
- RESET
- REVOKE
- ROLLBACK PREPARED
- ROLLBACK TO SAVEPOINT
- ROLLBACK
- SAVEPOINT
- SELECT
- SELECT INTO
- SET
- SET CONSTRAINTS
- SET ROLE
- SET SESSION AUTHORIZATION
- SET TRANSACTION
- SHOW
- START TRANSACTION
- TRUNCATE
- UNLISTEN
- UPDATE
- VACUUM
- II. PostgreSQL 客户端应用程序
- III. PostgreSQL 服务器应用程序
VII. 内部
- 章42. PostgreSQL 内部概貌
- 章43. 系统表
- 43.1. 概述
- 43.2. pg_aggregate
- 43.3. pg_am
- 43.4. pg_amop
- 43.5. pg_amproc
- 43.6. pg_attrdef
- 43.7. pg_attribute
- 43.8. pg_authid
- 43.9. pgauthmembers
- 43.10. pg_autovacuum
- 43.11. pg_cast
- 43.12. pg_class
- 43.13. pg_constraint
- 43.14. pg_conversion
- 43.15. pg_database
- 43.16. pg_depend
- 43.17. pg_description
- 43.18. pg_index
- 43.19. pg_inherits
- 43.20. pg_language
- 43.21. pg_largeobject
- 43.22. pg_listener
- 43.23. pg_namespace
- 43.24. pg_opclass
- 43.25. pg_operator
- 43.26. pg_pltemplate
- 43.27. pg_proc
- 43.28. pg_rewrite
- 43.29. pg_shdepend
- 43.30. pg_shdescription
- 43.31. pg_statistic
- 43.32. pg_tablespace
- 43.33. pg_trigger
- 43.34. pg_type
- 43.35. 系统视图
- 43.36. pg_cursors
- 43.37. pg_group
- 43.38. pg_indexes
- 43.39. pg_locks
- 43.40. pgpreparedstatements
- 43.41. pgpreparedxacts
- 43.42. pg_roles
- 43.43. pg_rules
- 43.44. pg_settings
- 43.45. pg_shadow
- 43.46. pg_stats
- 43.47. pg_tables
- 43.48. pgtimezoneabbrevs
- 43.49. pgtimezonenames
- 43.50. pg_user
- 43.51. pg_views
- 章44. 前/后端协议
- 章45. PostgreSQL 编码约定
- 章46. 本地语言支持
- 章47. 书写一个过程语言处理器
- 章48. 基因查询优化器
- 章49. 索引访问方法接口定义
- 章50. GiST 索引
- 章51. GIN 索引
- 章52. 数据库物理存储
- 章53. BKI 后端接口
- 章54. 规划器如何使用统计信息
VIII. 附录
文章来源于网络收集而来,版权归原创者所有,如有侵权请及时联系!
14.7. 支持的平台
到我们发布的时候为止,Postgres开发者社区已经证明 PostgreSQL 可以运行在下面平台上。某种平台是被支持的通常意味着按照这些指导,在这些平台上制作和安装了 PostgreSQL ,并且通过了回归测试。"Build farm"条目指向那些 PostgreSQL Build Farm 里活跃的测试机器。那些显示一个老版本的 PostgreSQL 的平台是那些在 8.2 版本发布的时候没有明确测试过的平台,但是我们认为它们还是可以运转的。
【注意】如果你在支持的平台上安装碰到问题,请向
<pgsql-bugs@postgresql.org>
或<pgsql-ports@postgresql.org>
发送邮件,而不是向这里列出的人发邮件。
操作系统 | 处理器 | 版本 | 报告 | 附注 |
---|---|---|---|---|
AIX | PowerPC | 8.2.0 | Build farm grebe (5.3, gcc 4.0.1); kookaburra (5.2, cc 6.0); asp (5.2, gcc 3.3.2) | see doc/FAQ_AIX , particularly if using AIX 5.3 ML3 |
AIX | RS6000 | 8.0.0 | Hans-Jürgen Schönig (<hs@cybertec.at> ), 2004-12-06 | see doc/FAQ_AIX |
BSD/OS | x86 | 8.1.0 | Bruce Momjian (<pgman@candle.pha.pa.us> ), 2005-10-26 | 4.3.1 |
Debian GNU/Linux | Alpha | 8.2.0 | Build farm hare (3.1, gcc 3.3.4) | |
Debian GNU/Linux | AMD64 | 8.2.0 | Build farm shad (4.0, gcc 4.1.2); kite (3.1, gcc 4.0); panda (sid, gcc 3.3.5) | |
Debian GNU/Linux | ARM | 8.2.0 | Build farm penguin (3.1, gcc 3.3.4) | |
Debian GNU/Linux | Athlon XP | 8.2.0 | Build farm rook (3.1, gcc 3.3.5) | |
Debian GNU/Linux | IA64 | 8.2.0 | Build farm dugong (unstable, icc 9.1.045) | |
Debian GNU/Linux | m68k | 8.0.0 | Noèl Köthe (<noel@debian.org> ), 2004-12-09 | sid |
Debian GNU/Linux | MIPS | 8.2.0 | Build farm otter (3.1, gcc 3.3.4) | |
Debian GNU/Linux | MIPSEL | 8.2.0 | Build farm lionfish (3.1, gcc 3.3.4); corgi (3.1, gcc 3.3.4) | |
Debian GNU/Linux | PA-RISC | 8.2.0 | Build farm manatee (3.1, gcc 4.0.1); kingfisher (3.1, gcc 3.3.5) | |
Debian GNU/Linux | PowerPC | 8.0.0 | Noèl Köthe (<noel@debian.org> ), 2004-12-15 | sid |
Debian GNU/Linux | Sparc | 8.1.0 | Build farm dormouse (3.1, gcc 3.2.5; 64-bit) | |
Debian GNU/Linux | x86 | 8.2.0 | Build farm wildebeest (3.1, gcc 3.3.5) | |
Fedora Linux | AMD64 | 8.2.0 | Build farm impala (FC6, gcc 4.1.1); bustard (FC5, gcc 4.1.0); wasp (FC5, gcc 4.1.0); viper (FC3, gcc 3.4.4) | |
Fedora Linux | PowerPC | 8.2.0 | Build farm sponge (FC5, gcc 4.1.0) | |
Fedora Linux | x86 | 8.2.0 | Build farm agouti (FC5, gcc 4.1.1); thrush (FC1, gcc 3.3.2) | |
FreeBSD | AMD64 | 8.2.0 | Build farm platypus (6, gcc 3.4.4); dove (6.1, gcc 3.4.4); ermine (6.1, gcc 3.4.4) | |
FreeBSD | x86 | 8.2.0 | Build farm minnow (6.1, gcc 3.4.4); echidna (6, gcc 3.4.2); herring (6, Intel cc 7.1) | |
Gentoo Linux | AMD64 | 8.1.0 | Build farm caribou (2.6.9, gcc 3.3.5) | |
Gentoo Linux | IA64 | 8.2.0 | Build farm stoat (2.6, gcc 3.3) | |
Gentoo Linux | PowerPC 64 | 8.2.0 | Build farm cobra (1.4.16, gcc 3.4.3) | |
Gentoo Linux | x86 | 8.2.0 | Build farm mongoose (1.6.14, icc 9.0.032) | |
HP-UX | IA64 | 8.2.0 | Tom Lane (<tgl@sss.pgh.pa.us> ), 2006-10-23 | 11.23, gcc 和 cc ; see doc/FAQ_HPUX |
HP-UX | PA-RISC | 8.2.0 | Tom Lane (<tgl@sss.pgh.pa.us> ), 2006-10-23 | 10.20 and 11.23, gcc 和 cc ; see doc/FAQ_HPUX |
IRIX | MIPS | 8.1.0 | Kenneth Marshall (<ktm@is.rice.edu> ), 2005-11-04 | 6.5, cc only |
Kubuntu Linux | AMD64 | 8.2.0 | Build farm rosella (5.10 "Breezy", gcc 4.0) | |
Mac OS X | PowerPC | 8.2.0 | Build farm tuna (10.4.2, gcc 4.0) | |
Mac OS X | x86 | 8.2.0 | Build farm jackal (10.4.8, gcc 4.0.1) | |
Mandriva Linux | x86 | 8.2.0 | Build farm gopher (Mandriva 2006, gcc 4.0.1) | |
NetBSD | m68k | 8.2.0 | Build farm osprey (2.0, gcc 3.3.3) | |
NetBSD | x86 | 8.2.0 | Build farm gazelle (3.0, gcc 3.3.3); canary (1.6, gcc 2.95.3) | |
OpenBSD | AMD64 | 8.2.0 | Build farm zebra (4.0, gcc 3.3.5) | |
OpenBSD | Sparc | 8.0.0 | Chris Mair (<list@1006.org> ), 2005-01-10 | 3.3 |
OpenBSD | Sparc64 | 8.2.0 | Build farm spoonbill (3.9, gcc 3.3.5) | |
OpenBSD | x86 | 8.2.0 | Build farm emu (4.0, gcc 3.3.5); guppy (3.8, gcc 3.3.5) | minor ecpg test failure on 3.8 |
Red Hat Linux | AMD64 | 8.1.0 | Tom Lane (<tgl@sss.pgh.pa.us> ), 2005-10-23 | RHEL 4 |
Red Hat Linux | IA64 | 8.1.0 | Tom Lane (<tgl@sss.pgh.pa.us> ), 2005-10-23 | RHEL 4 |
Red Hat Linux | PowerPC | 8.1.0 | Tom Lane (<tgl@sss.pgh.pa.us> ), 2005-10-23 | RHEL 4 |
Red Hat Linux | PowerPC 64 | 8.1.0 | Tom Lane (<tgl@sss.pgh.pa.us> ), 2005-10-23 | RHEL 4 |
Red Hat Linux | S/390 | 8.1.0 | Tom Lane (<tgl@sss.pgh.pa.us> ), 2005-10-23 | RHEL 4 |
Red Hat Linux | S/390x | 8.1.0 | Tom Lane (<tgl@sss.pgh.pa.us> ), 2005-10-23 | RHEL 4 |
Red Hat Linux | x86 | 8.1.0 | Tom Lane (<tgl@sss.pgh.pa.us> ), 2005-10-23 | RHEL 4 |
Slackware Linux | x86 | 8.1.0 | Sergey Koposov (<math@sai.msu.ru> ), 2005-10-24 | 10.0 |
Solaris | Sparc | 8.2.0 | Build farm hyena (Solaris 10, gcc 3.4.3) | see doc/FAQ_Solaris |
Solaris | x86 | 8.2.0 | Build farm dragonfly (Solaris 9, gcc 3.2.3); kudu (Solaris 9, cc 5.3) | see doc/FAQ_Solaris |
SUSE Linux | AMD64 | 8.1.0 | Josh Berkus (<josh@agliodbs.com> ), 2005-10-23 | SLES 9.3 |
SUSE Linux | IA64 | 8.0.0 | Reinhard Max (<max@suse.de> ), 2005-01-03 | SLES 9 |
SUSE Linux | PowerPC | 8.0.0 | Reinhard Max (<max@suse.de> ), 2005-01-03 | SLES 9 |
SUSE Linux | PowerPC 64 | 8.0.0 | Reinhard Max (<max@suse.de> ), 2005-01-03 | SLES 9 |
SUSE Linux | S/390 | 8.0.0 | Reinhard Max (<max@suse.de> ), 2005-01-03 | SLES 9 |
SUSE Linux | S/390x | 8.0.0 | Reinhard Max (<max@suse.de> ), 2005-01-03 | SLES 9 |
SUSE Linux | x86 | 8.0.0 | Reinhard Max (<max@suse.de> ), 2005-01-03 | 9.0, 9.1, 9.2, SLES 9 |
Tru64 UNIX | Alpha | 8.1.0 | Honda Shigehiro (<fwif0083@mb.infoweb.ne.jp> ), 2005-11-01 | 5.0, cc 6.1-011 |
Ubuntu Linux | x86 | 8.2.0 | Build farm caracara (6.06, gcc 4.0.3) | |
UnixWare | x86 | 8.2.0 | Build farm warthog (7.1.4, cc 4.2) | see doc/FAQ_SCO |
Windows | x86 | 8.2.0 | Build farm yak (XP SP2, gcc 3.4.2); bandicoot (Windows 2000 Pro, gcc 3.4.2); snake (Windows Server 2003 SP1, gcc 3.4.2); trout (Windows Server 2000 SP4, gcc 3.4.2) | see doc/FAQ_MINGW |
Windows with Cygwin | x86 | 8.2.0 | Build farm eel (W2K Server SP4, gcc 3.4.4) | see doc/FAQ_CYGWIN |
Yellow Dog Linux | PowerPC | 8.1.0 | Build farm carp (4.0, gcc 3.3.3) |
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论