postgresql start shutdown -优快云博客

本文链接：https://blog.youkuaiyun.com/iteye_14794/article/details/82637402

本文介绍了如何使用PostgreSQL进行数据迁移和备份，包括修改配置文件、启动迁移进程、使用pg_dump命令导出数据、pg_restore命令恢复数据等关键步骤。同时，通过实例演示了如何将数据从PostgreSQL 5432端口迁移至11780端口，并详细解释了相关命令的使用方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

./postgres -D /data/postgresql/ >> logfile 2>&1 &
 sed -i "s/#port = 5432/port = 11780/g" pg_data/postgresql.conf
netstat -antlp |grep 5432/11780
kill -15/9 pid
kill -INT 'head -i /home/sequoiadb/pgsql/pg_data/postgresqlmaster.pid'
http://www.php100.com/manual/PostgreSQL8/

http://www.php100.com/manual/PostgreSQL8/

/Volumes/pgAdmin3/pgAdmin3.app/Contents/SharedSupport/pg_dump --host 121.42. *.*--port 5432 --username "postgres" --no-password  --format custom --verbose --file "schemaName" "dbName"

/Volumes/pgAdmin3/pgAdmin3.app/Contents/SharedSupport/pg_restore --host ip --port 11780 --username "sdbadmin" --dbname "foo" --no-password  --schema lfchat --verbose "/Users/jade/Documents/lfchat_of_postgresql_5432"

postgres@iZ2893a7a8cZ:/usr/local/postgresql/bin$ ./pg_dump -n lfchat -d postgres -hlocalhost -p5432 -w -f ./postgresql.dump
postgres@iZ2893a7a8cZ:/usr/local/postgresql/bin$ ls
clusterdb   createuser  dropuser  logfile            pg_basebackup  pg_controldata  pg_dumpall      pg_resetxlog  pg_test_fsync   pg_xlogdump      postmaster  vacuumdb
createdb    dropdb      ecpg      oid2name           pgbench        pg_ctl          pg_isready      pg_restore    pg_test_timing  postgres         psql        vacuumlo
createlang  droplang    initdb    pg_archivecleanup  pg_config      pg_dump         pg_receivexlog  pg_standby    pg_upgrade      postgresql.dump  reindexdb
postgres@iZ2893a7a8cZ:/usr/local/postgresql/bin$