Created
June 30, 2023 10:06
-
-
Save df51d/51e5ae9b2bb52ca40014f2235a7e8c55 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- | |
-- PostgreSQL database cluster dump | |
-- | |
SET default_transaction_read_only = off; | |
SET client_encoding = 'UTF8'; | |
SET standard_conforming_strings = on; | |
-- | |
-- Drop databases (except postgres and template1) | |
-- | |
DROP DATABASE db; | |
-- | |
-- Drop roles | |
-- | |
DROP ROLE postgres; | |
-- | |
-- Roles | |
-- | |
CREATE ROLE postgres; | |
ALTER ROLE postgres WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN REPLICATION BYPASSRLS PASSWORD 'SCRAM-SHA-256$4096:ajqaeEnZlKP0GTbBByDpqA==$I1CYxffQTQ2PzmJPrVG0K7+TT3f9MIGDgHZ3jCYcwS8=:LSA8vpSOjE9cW82F+x0kxI9BJUzv5IzVO6TwaDYAWzY='; | |
-- | |
-- User Configurations | |
-- | |
-- | |
-- Databases | |
-- | |
-- | |
-- Database "template1" dump | |
-- | |
-- | |
-- PostgreSQL database dump | |
-- | |
-- Dumped from database version 15.1 (Debian 15.1-1.pgdg110+1) | |
-- Dumped by pg_dump version 15.1 (Debian 15.1-1.pgdg110+1) | |
SET statement_timeout = 0; | |
SET lock_timeout = 0; | |
SET idle_in_transaction_session_timeout = 0; | |
SET client_encoding = 'UTF8'; | |
SET standard_conforming_strings = on; | |
SELECT pg_catalog.set_config('search_path', '', false); | |
SET check_function_bodies = false; | |
SET xmloption = content; | |
SET client_min_messages = warning; | |
SET row_security = off; | |
UPDATE pg_catalog.pg_database SET datistemplate = false WHERE datname = 'template1'; | |
DROP DATABASE template1; | |
-- | |
-- Name: template1; Type: DATABASE; Schema: -; Owner: postgres | |
-- | |
CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'en_US.utf8'; | |
ALTER DATABASE template1 OWNER TO postgres; | |
\connect template1 | |
SET statement_timeout = 0; | |
SET lock_timeout = 0; | |
SET idle_in_transaction_session_timeout = 0; | |
SET client_encoding = 'UTF8'; | |
SET standard_conforming_strings = on; | |
SELECT pg_catalog.set_config('search_path', '', false); | |
SET check_function_bodies = false; | |
SET xmloption = content; | |
SET client_min_messages = warning; | |
SET row_security = off; | |
-- | |
-- Name: DATABASE template1; Type: COMMENT; Schema: -; Owner: postgres | |
-- | |
COMMENT ON DATABASE template1 IS 'default template for new databases'; | |
-- | |
-- Name: template1; Type: DATABASE PROPERTIES; Schema: -; Owner: postgres | |
-- | |
ALTER DATABASE template1 IS_TEMPLATE = true; | |
\connect template1 | |
SET statement_timeout = 0; | |
SET lock_timeout = 0; | |
SET idle_in_transaction_session_timeout = 0; | |
SET client_encoding = 'UTF8'; | |
SET standard_conforming_strings = on; | |
SELECT pg_catalog.set_config('search_path', '', false); | |
SET check_function_bodies = false; | |
SET xmloption = content; | |
SET client_min_messages = warning; | |
SET row_security = off; | |
-- | |
-- Name: DATABASE template1; Type: ACL; Schema: -; Owner: postgres | |
-- | |
REVOKE CONNECT,TEMPORARY ON DATABASE template1 FROM PUBLIC; | |
GRANT CONNECT ON DATABASE template1 TO PUBLIC; | |
-- | |
-- PostgreSQL database dump complete | |
-- | |
-- | |
-- Database "db" dump | |
-- | |
-- | |
-- PostgreSQL database dump | |
-- | |
-- Dumped from database version 15.1 (Debian 15.1-1.pgdg110+1) | |
-- Dumped by pg_dump version 15.1 (Debian 15.1-1.pgdg110+1) | |
SET statement_timeout = 0; | |
SET lock_timeout = 0; | |
SET idle_in_transaction_session_timeout = 0; | |
SET client_encoding = 'UTF8'; | |
SET standard_conforming_strings = on; | |
SELECT pg_catalog.set_config('search_path', '', false); | |
SET check_function_bodies = false; | |
SET xmloption = content; | |
SET client_min_messages = warning; | |
SET row_security = off; | |
-- | |
-- Name: db; Type: DATABASE; Schema: -; Owner: postgres | |
-- | |
CREATE DATABASE db WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'en_US.utf8'; | |
ALTER DATABASE db OWNER TO postgres; | |
\connect db | |
SET statement_timeout = 0; | |
SET lock_timeout = 0; | |
SET idle_in_transaction_session_timeout = 0; | |
SET client_encoding = 'UTF8'; | |
SET standard_conforming_strings = on; | |
SELECT pg_catalog.set_config('search_path', '', false); | |
SET check_function_bodies = false; | |
SET xmloption = content; | |
SET client_min_messages = warning; | |
SET row_security = off; | |
SET default_tablespace = ''; | |
SET default_table_access_method = heap; | |
-- | |
-- Name: User; Type: TABLE; Schema: public; Owner: postgres | |
-- | |
CREATE TABLE public."User" ( | |
id integer NOT NULL | |
); | |
ALTER TABLE public."User" OWNER TO postgres; | |
-- | |
-- Name: User_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | |
-- | |
CREATE SEQUENCE public."User_id_seq" | |
AS integer | |
START WITH 1 | |
INCREMENT BY 1 | |
NO MINVALUE | |
NO MAXVALUE | |
CACHE 1; | |
ALTER TABLE public."User_id_seq" OWNER TO postgres; | |
-- | |
-- Name: User_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | |
-- | |
ALTER SEQUENCE public."User_id_seq" OWNED BY public."User".id; | |
-- | |
-- Name: User id; Type: DEFAULT; Schema: public; Owner: postgres | |
-- | |
ALTER TABLE ONLY public."User" ALTER COLUMN id SET DEFAULT nextval('public."User_id_seq"'::regclass); | |
-- | |
-- Data for Name: User; Type: TABLE DATA; Schema: public; Owner: postgres | |
-- | |
COPY public."User" (id) FROM stdin; | |
\. | |
-- | |
-- Name: User_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | |
-- | |
SELECT pg_catalog.setval('public."User_id_seq"', 1, false); | |
-- | |
-- Name: User User_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres | |
-- | |
ALTER TABLE ONLY public."User" | |
ADD CONSTRAINT "User_pkey" PRIMARY KEY (id); | |
-- | |
-- PostgreSQL database dump complete | |
-- | |
-- | |
-- Database "postgres" dump | |
-- | |
-- | |
-- PostgreSQL database dump | |
-- | |
-- Dumped from database version 15.1 (Debian 15.1-1.pgdg110+1) | |
-- Dumped by pg_dump version 15.1 (Debian 15.1-1.pgdg110+1) | |
SET statement_timeout = 0; | |
SET lock_timeout = 0; | |
SET idle_in_transaction_session_timeout = 0; | |
SET client_encoding = 'UTF8'; | |
SET standard_conforming_strings = on; | |
SELECT pg_catalog.set_config('search_path', '', false); | |
SET check_function_bodies = false; | |
SET xmloption = content; | |
SET client_min_messages = warning; | |
SET row_security = off; | |
DROP DATABASE postgres; | |
-- | |
-- Name: postgres; Type: DATABASE; Schema: -; Owner: postgres | |
-- | |
CREATE DATABASE postgres WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'en_US.utf8'; | |
ALTER DATABASE postgres OWNER TO postgres; | |
\connect postgres | |
SET statement_timeout = 0; | |
SET lock_timeout = 0; | |
SET idle_in_transaction_session_timeout = 0; | |
SET client_encoding = 'UTF8'; | |
SET standard_conforming_strings = on; | |
SELECT pg_catalog.set_config('search_path', '', false); | |
SET check_function_bodies = false; | |
SET xmloption = content; | |
SET client_min_messages = warning; | |
SET row_security = off; | |
-- | |
-- Name: DATABASE postgres; Type: COMMENT; Schema: -; Owner: postgres | |
-- | |
COMMENT ON DATABASE postgres IS 'default administrative connection database'; | |
-- | |
-- PostgreSQL database dump complete | |
-- | |
-- | |
-- PostgreSQL database cluster dump complete | |
-- | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment