Home Database Mysql Tutorial Ubuntu上的phppgAdmin安装及配置

Ubuntu上的phppgAdmin安装及配置

Jun 07, 2016 pm 04:46 PM

一直想将phppgamdin布署好,但在Redhat和Windows下安装时均碰到了不同的问题,因为对web的东东不熟悉,最终努力后,以失败收

一直想将phppgamdin布署好,但在RedHat和Windows下安装时均碰到了不同的问题,因为对web的东东不熟悉,最终努力后,以失败收场。详见:

   周末突然来了兴趣,装了个Ubuntu,昨晚再次试了下phppgAdmin,终于配置成功。记录过程:

   1. 使用Ubuntu自带的“新立得软件包管理器”安装php5, apache2, postgresql8.4.2。

   2. 安装完成后,测试一下apache2, 浏览器中输入,显示It`s works.。

   3. 为了方便起见, 直接执行:cp /usr/share/phppgadmin /var/www,将phppgadmin的目录直接拷贝到apache2默认目录下,再进入/var/www,将index.html删除。

   4.进入/var/www/conf,,修改config.inc.php文件,将下面配置项由true改为false。 

  • // If extra login security is true, then logins via phpPgAdmin with no  
  • // password or certain usernames (pgsql, postgres, root, administrator)  
  • // will be denied. Only set this false once you have read the FAQ and  
  • // understand how to change PostgreSQL's pg_hba.conf to enable  
  • // passworded local connections.  
  • $conf['extra_login_security'] = false;  
  •   5.关于postgre上面的监听打开请参考之前博文,这里不再讲述。

      6.重启apache2, 执行:service apache2 restart

      7.用浏览器中输入locathost或本机IP即可,接下来的一事情跟逛CSDN论坛一样,会上网就会使用。不再讲述。

      8.俗话说,有图有真像,抓几张贴上来玩:

      a.整体视图:

    Ubuntu上的phppgAdmin安装及配置

      


      b.执行SQL语句:

    Ubuntu上的phppgAdmin安装及配置

     c.创建函数或存储过程的界面:

    Ubuntu上的phppgAdmin安装及配置

    linux

    Statement of this Website
    The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

    Hot AI Tools

    Undresser.AI Undress

    Undresser.AI Undress

    AI-powered app for creating realistic nude photos

    AI Clothes Remover

    AI Clothes Remover

    Online AI tool for removing clothes from photos.

    Undress AI Tool

    Undress AI Tool

    Undress images for free

    Clothoff.io

    Clothoff.io

    AI clothes remover

    Video Face Swap

    Video Face Swap

    Swap faces in any video effortlessly with our completely free AI face swap tool!

    Hot Tools

    Notepad++7.3.1

    Notepad++7.3.1

    Easy-to-use and free code editor

    SublimeText3 Chinese version

    SublimeText3 Chinese version

    Chinese version, very easy to use

    Zend Studio 13.0.1

    Zend Studio 13.0.1

    Powerful PHP integrated development environment

    Dreamweaver CS6

    Dreamweaver CS6

    Visual web development tools

    SublimeText3 Mac version

    SublimeText3 Mac version

    God-level code editing software (SublimeText3)

    When might a full table scan be faster than using an index in MySQL? When might a full table scan be faster than using an index in MySQL? Apr 09, 2025 am 12:05 AM

    Full table scanning may be faster in MySQL than using indexes. Specific cases include: 1) the data volume is small; 2) when the query returns a large amount of data; 3) when the index column is not highly selective; 4) when the complex query. By analyzing query plans, optimizing indexes, avoiding over-index and regularly maintaining tables, you can make the best choices in practical applications.

    Explain InnoDB Full-Text Search capabilities. Explain InnoDB Full-Text Search capabilities. Apr 02, 2025 pm 06:09 PM

    InnoDB's full-text search capabilities are very powerful, which can significantly improve database query efficiency and ability to process large amounts of text data. 1) InnoDB implements full-text search through inverted indexing, supporting basic and advanced search queries. 2) Use MATCH and AGAINST keywords to search, support Boolean mode and phrase search. 3) Optimization methods include using word segmentation technology, periodic rebuilding of indexes and adjusting cache size to improve performance and accuracy.

    Can I install mysql on Windows 7 Can I install mysql on Windows 7 Apr 08, 2025 pm 03:21 PM

    Yes, MySQL can be installed on Windows 7, and although Microsoft has stopped supporting Windows 7, MySQL is still compatible with it. However, the following points should be noted during the installation process: Download the MySQL installer for Windows. Select the appropriate version of MySQL (community or enterprise). Select the appropriate installation directory and character set during the installation process. Set the root user password and keep it properly. Connect to the database for testing. Note the compatibility and security issues on Windows 7, and it is recommended to upgrade to a supported operating system.

    Difference between clustered index and non-clustered index (secondary index) in InnoDB. Difference between clustered index and non-clustered index (secondary index) in InnoDB. Apr 02, 2025 pm 06:25 PM

    The difference between clustered index and non-clustered index is: 1. Clustered index stores data rows in the index structure, which is suitable for querying by primary key and range. 2. The non-clustered index stores index key values ​​and pointers to data rows, and is suitable for non-primary key column queries.

    What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)? What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)? Mar 21, 2025 pm 06:28 PM

    Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]

    How do you handle large datasets in MySQL? How do you handle large datasets in MySQL? Mar 21, 2025 pm 12:15 PM

    Article discusses strategies for handling large datasets in MySQL, including partitioning, sharding, indexing, and query optimization.

    MySQL: Simple Concepts for Easy Learning MySQL: Simple Concepts for Easy Learning Apr 10, 2025 am 09:29 AM

    MySQL is an open source relational database management system. 1) Create database and tables: Use the CREATEDATABASE and CREATETABLE commands. 2) Basic operations: INSERT, UPDATE, DELETE and SELECT. 3) Advanced operations: JOIN, subquery and transaction processing. 4) Debugging skills: Check syntax, data type and permissions. 5) Optimization suggestions: Use indexes, avoid SELECT* and use transactions.

    The relationship between mysql user and database The relationship between mysql user and database Apr 08, 2025 pm 07:15 PM

    In MySQL database, the relationship between the user and the database is defined by permissions and tables. The user has a username and password to access the database. Permissions are granted through the GRANT command, while the table is created by the CREATE TABLE command. To establish a relationship between a user and a database, you need to create a database, create a user, and then grant permissions.

    See all articles