Unable to connect to PG Schema [Jun 16]

Discord-Discussions
1

:raising_hand_man: lunax asked

Hi, I found I cannot connect to existing pg schema. Even if I set (manual in JSON or in GUI) the searchPath it always use public schema.

2

:man_bald: dstala replied

Could you help us with additional information

- NocoDB project information (https://www.youtube.com/watch?v=AUSNN-RCwhE)

- Working on self-hosted version? or using cloud service provider?

3

:raising_hand_man: lunax replied

selfhosted:

```

Node: v12.22.12

Arch: x64

Platform: linux

Docker: true

Database: pg

ProjectOnRootDB: false

RootDB: pg

PackageVersion: 0.91.10```

4

:raising_hand_man: lunax replied

But now started to work…

5

:raising_hand_man: lunax replied

I was trying for past hour and just randomly started to work.

6

:man_bald: dstala replied

any error that you saw?

7

:raising_hand_man: lunax replied

Then? No, just empty tables list.

8

:raising_hand_man: lunax replied

and when I creating tables it created it in public schema.

9

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs