Please help to update baserow self hosted from 1.23.0 to 1.28.0

Hello!
I have baserow self hosted version 1.23.2 installed and i need to update it to 1.28.0
So according to the docs, i stoped the container with this command:
docker stop baserow

then i edited the docker-compose.yml and changed the baserow version from 1.23.2 to 1.28.0

and i used those 2 commands:
docker-compose pull
docker-compose up -d

but basrow instance didnt start, i cant access it throw my browser, so i checked with this command:
docker logs -f baserow

which gave me this result:

so i guess i need to update the postgre to version 15, and here i have a little problem :slight_smile: i failed to do that on my own :grinning:

here is my docker-compose.yml

version: "3.7"
     services:
        baserow:
            container_name: baserow
            image: baserow/baserow:1.28.0
            environment: 
                 baserow_public_URL:  "https//:base.avivir.eg'
            ports:
                 -"80:80"
                 -"443:443"
            volumes:
                     -baserow_data:/baserow/data
volumes:
    baserow_data:

according to the docs, i stop the container with docker stop baserow, then i ran this command"

docker run \
  --name baserow-pgautoupgrade \
  -e baserow_public_URL:  "https//:base.avivir.eg' \
  --restart no \
  baserow/baserow-pgautoupgrade:1.28.0
docker run --name baserow-pgautoupgrade \
  -e BASEROW_PUBLIC_URL="https://base.avivir.ru" \
  -v baserow_data:/baserow/data \                                  
  --restart no \                                     
  baserow/baserow-pgautoupgrade:1.28.0

but i got this error :
docker: invalid reference fortmat

I obviously dont understand how this docker command works :slight_smile: so could yu please give me the right full command to upgrade postgre and get baserow inctand up and runinng again?

Also? please tell me what should i learn to get this right? :grinning:

Thanks in advance!

Hi @ahmedsobeyh,

You posted two commands here but the first one doesn’t seem like a valid command. Are you sure that you are running the proper valid docker command from the docs?

I’m trying to upgrade my baserow, which i installed using docker-compose.
Here is my docker-compose.yml

version: "3.7"
     services:
        baserow:
            container_name: baserow
            image: baserow/baserow:1.23.2
            environment: 
                 baserow_public_URL:  "https//:base.avivir.ru'
            ports:
                 -"80:80"
                 -"443:443"
            volumes:
                     -baserow_data:/baserow/data
volumes:
    baserow_data:

as far as i know, baserow is using the embeded postgre version 11

i tried the method as shown in this docs but git pull somehow doesnt work! ( my system is ubuntu server 22.04

i tried to manually change the version of the desired Baserow version in the docker-compose.yml

baserow@baserow:~$ sudo docker compose down
WARN[0000] /home/baserow/docker-compose.yml: `version` is obsolete 
[+] Running 2/2
 ✔ Container baserow        Removed                                                                                        0.0s 
 ✔ Network baserow_default  Removed                                                                                        0.2s 
baserow@baserow:~$ sudo nano docker-compose.yml
baserow@baserow:~$ sudo docker compose up --build
WARN[0000] /home/baserow/docker-compose.yml: `version` is obsolete 
[+] Running 1/0
 ✔ Container baserow  Created                    

baserow exited with code 1
baserow@baserow:~$ sudo docker compose pull
WARN[0000] /home/baserow/docker-compose.yml: `version` is obsolete 
[+] Pulling 1/1
 ✔ baserow Pulled                                                                                                          1.3s 
baserow@baserow:~$ sudo docker compose up -d
WARN[0000] /home/baserow/docker-compose.yml: `version` is obsolete 
[+] Running 1/1
 ✔ Container baserow  Started                                                                                              0.0s 
baserow@baserow:~$ docker ps -a
CONTAINER ID   IMAGE                                  COMMAND               CREATED          STATUS                      PORTS     NAMES
c68d43d34c43   baserow/baserow:1.28.0                 "/baserow.sh start"   2 minutes ago    Exited (1) 11 seconds ago             baserow
4391e93f9574   baserow/baserow-pgautoupgrade:1.28.0   "/baserow.sh start"   36 minutes ago   Exited (1) 36 minutes ago             baserow-pgautoupgrade
7cb883c1409e   hello-world                            "/hello"              7 months ago     Exited (0) 7 months ago               trusting_wilson
baserow@baserow:~$ docker ps
CONTAINER ID   IMAGE     COMMAND   CREATED   STATUS    PORTS     NAMES

also got nothing))

Could you please tell me what should i do to update it to 1.28.0 with postgre 15?
which commands should i use?

Thanks a lot in advance!

@davide Can you help here with the PostgreSQL update?