Public bug reported: Binary package hint: postgresql-8.1
Ubuntu Server LTS 6.06.1 with kernel 2.6.15-27-amd64-server #1 SMP. After install Ubuntu, UTF-8 cause problems with UPPER() function for my applications. I change locales to ISO-8859-1 and I do initdb again and UPPER() problem dissapear but now doing a: pg_dump --verbose --oids --format=t --file= mybase.backup mybase I try to restore in other database named p_mybase with: pg_restore --verbose --no-owner --no-privileges --dbname=p_mybase mybase.backup it restore all data but don't create indexs, none of them. ** Affects: postgresql-8.1 (Ubuntu) Importance: Undecided Status: Unconfirmed -- pg_restore don't create index https://launchpad.net/bugs/75831 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs