Giter VIP home page Giter VIP logo

Comments (4)

DrMichael avatar DrMichael commented on June 5, 2024

Have a look at teslamate.bck. Probably there is an error message in it.

from teslamate.

danielraffel avatar danielraffel commented on June 5, 2024

Good point, sorry for not sharing. Here's the contents of teslamate.bck any suggestions?

--
-- PostgreSQL database dump
--

-- Dumped from database version 14.10 (Debian 14.10-1.pgdg120+1)
-- Dumped by pg_dump version 14.10 (Debian 14.10-1.pgdg120+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;

--
-- PostgreSQL database dump complete
--


when I connect to documents-macmini-database-1 in docker desktop (which is in use and 50mb) using:
docker compose exec database bash

and then connect to the db:
psql -U teslamate

and then list my DBs:
\l

I see the following:

                                  List of databases
   Name    |   Owner   | Encoding |  Collate   |   Ctype    |    Access privileges    
-----------+-----------+----------+------------+------------+-------------------------
 postgres  | teslamate | UTF8     | en_US.utf8 | en_US.utf8 | 
 template0 | teslamate | UTF8     | en_US.utf8 | en_US.utf8 | =c/teslamate           +
           |           |          |            |            | teslamate=CTc/teslamate
 template1 | teslamate | UTF8     | en_US.utf8 | en_US.utf8 | =c/teslamate           +
           |           |          |            |            | teslamate=CTc/teslamate
 teslamate | teslamate | UTF8     | en_US.utf8 | en_US.utf8 | 
(4 rows)

but I cannot figure out how to export the db.

I have the original docker-compose.yml file and I am running the pgdump command from that directory in terminal. I dunno if docker was started precisely from where the file is currently stored and/or whether that is even an issue.

on the terminal in the desktop I continue to only get a 545 byte file when I attempt to run
docker compose exec -T database pg_dump -U teslamate teslamate > teslamate.bck

from teslamate.

JakobLichterfeld avatar JakobLichterfeld commented on June 5, 2024

Please give it a try without the -T. As docker compose (which is docker compose v2) omit the -T automatically if not called from a TTY.

from teslamate.

github-actions avatar github-actions commented on June 5, 2024

This issue has been automatically marked as stale because it has not had recent activity. It will be closed in 7 days if no further activity occurs. Thank you for your contributions.

from teslamate.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.