469,902 Members | 1,976 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,902 developers. It's quick & easy.

PostgreSQL on SMB/CIFS Shares on FreeBSD 5

I have an embedded system running FreeBSD (5.1) that does not have any local
(rotating) storage (i.e disk drives).

PostgreSQL also runs on this box and (at this point) has two tables. It is
an extremely simple PostgreSQL configuration with the tables having less
than 20 fields each, and no relations between the tables.

However, because there isn't any (substantial) local storage available on
the Compact Flash, and the tables have the potential to grow fairly large,
Windows-based shares are being used (via PostgreSQL's 'initlocation') as the
backing store for the tables.

Moreover, setting the system up consisted of:
1. Setting and exporting PGDATA2=/var/nsg/dbNSG in ~/.profile
2. mount_smbfs <user@server/share> /var/nsg/dbNSG
3. initdb (default location (/usr/local/pgsql/data) (on the flash))
4. start PostgreSQL
5. createuser -A -D nsg
6. initlocation -D PGDATA2
7. createdb -D PGDATA2 -O nsg nsg
8. (create tables)

This all completes successfully, the problems begin while attempting to
populate the tables. It seems that attempts to add specific records causes
my C/libpq application to forever block on 'postgres'. My app is blocked on
select(2) (via pg_exec('INSERT...')) and PostgreSQL is blocked on a
semaphore. And for the record, the application and PostgreSQL perform
flawlessly if step 2 (above) is skipped. In other words, there seems to be
problem when SMB/CIFS is layered in.

Does anyone have any information that might shed a little light? Anyone use
SMB/CIFS as the backing store for PostgreSQL?

Thanks in advance!
robo
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #1
0 1157

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Mike | last post: by
1 post views Thread by Otis Green | last post: by
1 post views Thread by Robert Fitzpatrick | last post: by
reply views Thread by Adam Smith | last post: by
2 posts views Thread by Victor Alvarez | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.