I Have just installed version Postgresql-8.4.0 and when I run initdb -E utf8
it tells me that the current local (LATIN1 or rather LC_CTYPE) cannot accept
the utf8. Then when I run initdb with the default local, I cannot create a
utf8 database any way (be it in psql or pgadmin3).
Any hint?
I use Li
mitra nazemian schrieb:
hi,
I want too implement ldap authentication in PostgreSQL in linux, but I cant.
Please help me...
Tanx
Hi,
first you should understand the basics of authentication in postgresql.
http://www.postgresql.org/docs/current/static/client-authentication.html
Then jump to thi
On Thu, Jul 16, 2009 at 12:18 PM, Joshua Daniel Franklin wrote:
> I'm having a problem with Postgres 7.4 on RHEL 4 (Nahant Update 8).
> It seems that pg_database disappeared some time ago (I think before
> my oldest backups, unfortunately).
>
> I searched and found some mention of REINDEX but I'm
Joshua Daniel Franklin escribió:
> On Thu, Jul 16, 2009 at 12:18 PM, Joshua Daniel Franklin wrote:
> > I'm having a problem with Postgres 7.4 on RHEL 4 (Nahant Update 8).
> > It seems that pg_database disappeared some time ago (I think before
> > my oldest backups, unfortunately).
> >
> > I search
On Mon, Jul 20, 2009 at 8:39 AM, Alvaro Herrera wrote:
> Joshua Daniel Franklin escribió:
>> > postgres -P -D /usr/local/databases/pgsql/data pg_database
>> > FATAL: database "pg_database" does not exist
>>
>> So... does that 'FATAL: database "pg_database" does not exist' message
>> mean it's gam
Joshua Daniel Franklin escribió:
> xbrain_queries=# \d
> No relations found.
> xbrain_queries=# \l
>List of databases
> Name | Owner | Encoding
> --+---+--
> (0 rows)
Hmmm, seems your Xid counter wrapped around. Have you vacuumed the
system catalogs in that database? Partic
Joshua Daniel Franklin writes:
> NOTICE: table "pg_database" was reindexed
So you did the reindex ...
> xbrain_queries=# \l
>List of databases
> Name | Owner | Encoding
> --+---+--
> (0 rows)
... and it didn't help. I think this shows that the indexes weren't the
problem.
On Mon, Jul 20, 2009 at 11:00 AM, Alvaro Herrera wrote:
> Joshua Daniel Franklin escribió:
>
>> xbrain_queries=# \d
>> No relations found.
>
> Hmmm, seems your Xid counter wrapped around. Have you vacuumed the
> system catalogs in that database? Particularly pg_class, pg_attribute
> etc ...
>
> S
We plan to migrate from 8.1.X to 8.2 . I understand that XID
wraparound has changed with the 8.2 release (maintained per table
versus entire database). XID wraparound is important for us as we have
large databases (800Gb +) and also use lot of partitioned inherited
tables.
Is XID tracking done per
Anj Adu escribió:
> We plan to migrate from 8.1.X to 8.2 . I understand that XID
> wraparound has changed with the 8.2 release (maintained per table
> versus entire database). XID wraparound is important for us as we have
> large databases (800Gb +) and also use lot of partitioned inherited
> table
Hello People,
I upgraded to a 64 bits System. Now, everything is OK. Thnk you guys.
On Sat, Jul 11, 2009 at 2:19 AM, Scott Marlowe wrote:
> On Fri, Jul 10, 2009 at 10:27 PM, wrote:
> >
> > 2G per process is plenty ...and useful if you have large data warehouse
> style queries which are long runn
Thanks. It worked.
Ibrahim
On Mon, Jul 20, 2009 at 11:58 AM, J. Carlos Muro wrote:
> I think you need to setup locale of the user who inits/runs the cluster
> (generally "postgres') to unicode in order to init a unicode cluster.
> Try to set your locale environment variables to for example
> LAN
12 matches
Mail list logo
