Hello,
I am merging two forums together via the tutorial present here.
I’m getting stuck on the command gunzip < /path/to/data/other-2018-08-02-134227-v2018xxx.tar.gz | psql -d copyme
It returns me plenty of lines with import errors in unintelligible characters.
Here are the steps performed:
- Discourse installation via official method on VPS.
- Import via GUI of the backup to merge (forumother)
- Backup of the latter (to have a backup with the latest version of discourse)
- Import of the backup of the destination forum (forumdest)
- Import of the backup of
forumother
via SFTP in the folder/var/discourse/shared/standalone/backups/default
.
Then I go to the above folder and run the command tar xvzf forumother.tar.gz
(with the real name of the backup).
Direction cd /var/discourse
then ./launcher enter app
sudo -u postgres psql
and CREATE DATABASE "copyme" ENCODING = 'utf8';
and I quit with ``q
It’s now that I’m stuck.
The command gunzip < public/backups/default/forumother.tar.gz | psql -d copyme
does not work as it is.
The error is psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: role "root" does not exist
I can see that this is a connection problem, but I don’t see how to solve it.
I tried logging in as the postgres user su - postgres
and then running the command gunzip ...
but that’s when the command output is completely inconsistent.
postgres@testforum-app:~$ gunzip < /var/www/discourse/public/backups/default/forum-francophon
e-home-assistant-2022-04-24-120337-v20220407195246.tar.gz | psql -d copyme3
invalid command \{wB
invalid command \֬IeY┴WPC<P%£6◆BP␌U@Q█5
␋┼┴▒┌␋␍ ␌└└▒┼␍ \
␋┼┴▒┌␋␍ ␌└└▒┼␍ \];*░Һ
␋┼┴▒┌␋␍ ␌└└▒┼␍ \FMݤ!≥"≠±↓QʏCMHȽ◆)&E/M6!◆┐
␋┼┴▒┌␋␍ ␌└└▒┼␍ \↑
ERROR: ␋┼┴▒┌␋␍ ␉≤├␊ ␊─┤␊┼␌␊ ° ␊┼␌␍␋┼± "UTF8": █│␊° █│37 █│49
ERROR: ␋┼┴▒┌␋␍ ␉≤├␊ ␊─┤␊┼␌␊ ° ␊┼␌␍␋┼± "UTF8": █│␉␉
␋┼┴▒┌␋␍ ␌└└▒┼␍ \лT4٩3┼←
␋┼┴▒┌␋␍ ␌└└▒┼␍ \^EC◆≥]B2Ɣ?8[N→^G9←@±4?WY°O͖↓HY┬4
ERROR: ␋┼┴▒┌␋␍ ␉≤├␊ ␊─┤␊┼␌␊ ° ␊┼␌␍␋┼± "UTF8": █│␉2
...
invalid command \UWXJ&qkW*SQy2漆&%>N≤OI2·^;├
␋┼┴▒┌␋␍ ␌└└▒┼␍ \2d-ɸjrR*֬&^_'Ƶ褚N2HhIu
S3
invalid command \VI
invalid command \}Jݐ
invalid command \BQNr|΅tU~#_k#D,WHfqtC
invalid command \syJx%
invalid command \Eq
invalid command \-KmJ
invalid command \
invalid command \/ly=}E~ԚYj>nO
invalid command \SM!{Co~UH^x)*O}9vUǙk}LQ
invalid command \eH<=gTRPR1}{~/t!wiwhӒCґJmCĥ=;O^p*-
invalid command \gq{cr}N;.
invalid command \2p3a-.C:m_Y@c<4/mvΩߵj]SޙU"O}$[
invalid command \)
invalid command \
invalid command \VOtDIM2+͆Yq4R
invalid command \WHElnHBDm%?PBFrOڙ}d"
invalid command \PjsחPmqJ[B@$Wt*!&|Zz))Q6AJY%!/6=JRJBPþA)YTZ┘=!M^␉CO)→└␋9┤E▒5█E≤Pі
T│ȐOȾB)W┌Ad:}1,kNDoO')G^W5:B␊I│7!N;─À@#┘
┼┴▒┌␋␍ ␌└└▒┼␍ \6◆3
␋┼┴▒┌␋␍ ␌└└▒┼␍ \2�Ψ)VD4π]
ERROR: ␋┼┴▒┌␋␍ ␉≤├␊ ␊─┤␊┼␌␊ ° ␊┼␌␍␋┼± "UTF8": █│89
├±␊@├␊├°┤└↑▒:·$
I tried to search on the forum, but I didn’t find anything on this.
So I count on your help and thank you in advance.
PS: My English is bad, so it’s possible that I’m not using the right words for a good search on the forum or I’m misinterpreting the tutorial quoted at the beginning of this post.