<?xml version="1.0" encoding="UTF-8"?><rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>Serov.eu &#187; postgres</title>
	<atom:link href="https://serov.eu/?feed=rss2&#038;tag=postgres" rel="self" type="application/rss+xml" />
	<link>https://serov.eu</link>
	<description>Блог программиста</description>
	<lastBuildDate>Thu, 30 Apr 2026 12:31:53 +0000</lastBuildDate>
	<language>ru-RU</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=4.1.15</generator>
	<item>
		<title>Backup/Restore a dockerized PostgreSQL database</title>
		<link>https://serov.eu/?p=743</link>
		<comments>https://serov.eu/?p=743#comments</comments>
		<pubDate>Sun, 08 Aug 2021 20:51:52 +0000</pubDate>
		<dc:creator><![CDATA[Evgen]]></dc:creator>
				<category><![CDATA[Программирование]]></category>
		<category><![CDATA[postgres]]></category>

		<guid isPermaLink="false">https://serov.eu/?p=743</guid>
		<description><![CDATA[Backup your databases docker exec -t your-db-container pg_dumpall -c -U postgres > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql Restore your databases cat your_dump.sql &#124; docker exec -i your-db-container psql -U postgres с архивированием docker exec -t your-db-container pg_dumpall -c -U postgres &#124; gzip > /var/data/postgres/backups/dump_date +%d-%m-%Y"_"%H_%M_%S.gz можно бекапить через докер образ pgbackups: container_name: Backup image: prodrigestivill/postgres-backup-local restart: always volumes: &#8230; <a href="https://serov.eu/?p=743" class="more-link">Читать далее <span class="screen-reader-text">Backup/Restore a dockerized PostgreSQL database</span></a>]]></description>
				<content:encoded><![CDATA[<p>Backup your databases</p>
<pre>
docker exec -t your-db-container pg_dumpall -c -U postgres > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql
</pre>
<p>Restore your databases</p>
<pre>
cat your_dump.sql | docker exec -i your-db-container psql -U postgres
</pre>
<p>с архивированием</p>
<pre>
docker exec -t your-db-container pg_dumpall -c -U postgres | gzip > /var/data/postgres/backups/dump_date +%d-%m-%Y"_"%H_%M_%S.gz
</pre>
<p>можно бекапить через докер образ</p>
<pre>
 pgbackups:
    container_name: Backup
    image: prodrigestivill/postgres-backup-local
    restart: always
    volumes:
      - ./backup:/backups
    links:
      - db:db
    depends_on:
      - db
    environment:
      - POSTGRES_HOST=db
      - POSTGRES_DB=${DB_NAME} 
      - POSTGRES_USER=${DB_USER}
      - POSTGRES_PASSWORD=${DB_PASSWORD}
      - POSTGRES_EXTRA_OPTS=-Z9 --schema=public --blobs
      - SCHEDULE=@every 0h30m00s
      - BACKUP_KEEP_DAYS=7
      - BACKUP_KEEP_WEEKS=4
      - BACKUP_KEEP_MONTHS=6
      - HEALTHCHECK_PORT=81
</pre>
<p>Бонус &#8212; репликация</p>
<p>https://medium.com/@2hamed/replicating-postgres-inside-docker-the-how-to-3244dc2305be</p>
]]></content:encoded>
			<wfw:commentRss>https://serov.eu/?feed=rss2&#038;p=743</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>
