[ADMIN] Migration problems with encoding.

the postgresql version. How can i resolve this with a database about 16 Gb? Are there any document about how to solve this? Thank you very much. -- Manuel Trujillo Albarral Responsable de Sistemas VLEX NETWORKS S.L. Telf: 93-272.26.85 ext. 111 Jabber/GoogleTalk [EMAIL PROTECTED] http

[ADMIN] about rserv

much. Have a nice day ;-) TooManySecrets -- Manuel Trujillo [EMAIL PROTECTED] Technical Engineer http://www.motograndprix.com Dorna Sports S.L. +34 93 4702864 ---(end of broadcast)--- TIP 6: Have you searched our list archives?

[ADMIN] continuing with rserv replication

Hi. Anybody know if is possible to make more of one table "active for trigger" with the MasterAddTable program utilitie? Actually, only one table with one field is allowed for trigger changes on the table, and I want to make more of one field for trigger into a table. Thank'

[ADMIN] about the time of a process

Hi. Another question... How many take to time a backend process if it haven't gos "traffic" (or run any query), to dead?? Have postgresql a SET command for determinate this question? I will apologize about my bad english... sorry please. Thank's for all. -- Manuel Tru

[ADMIN] grant access

Hi. I'm using a postgresql-7.1.3 compiled into a Debian Potato. I need to grant access "select" to one user in all tables. How can I make this into "one command", without make "grant 1 to x", "grant 2 to x", etc, etc Thank you very much, an

[ADMIN] table test

is the best way to know the better type of table of this two types? Thank you very much! Have a nice day ;-) TooManySecrets -- Manuel Trujillo [EMAIL PROTECTED] Technical Engineer http://www.motograndprix.com Dorna Sports S.L. +34 93 4702864 ---(end

Re: [ADMIN] table test

||| > > > > > > > > > How is the best way to know the better type of table of this two types? Thank you very much. Have a nice day ;-) TooManySecrets -- Manuel Trujillo [EMAIL PROTECTED] Technical Engineer http://www.motograndprix.co

[ADMIN] wiew's & cache

Hi. Can Postgresql make a cache of different view's? Is for a dynamic website. Thank you. -- Manuel Trujillo [EMAIL PROTECTED] Technical Engineer http://www.motograndprix.com Dorna Sports S.L. +34 93 4702864 ---(end of broa

[ADMIN] zlib & readline

ebian GNU/Linux with zlib1g-dev and libreadline4-dev packages installed, and this provides zlib.h and readline, history.h, etc. Thank you very much. Have a nice day ;-) TooManySecrets -- Manuel Trujillo [EMAIL PROTECTED] Technical Engineer http://www.motograndprix.com Dorna Sports S.L.

[ADMIN] problems with postgresql speed

The result take a minute, or more, to show the results. The postgresql.conf I used is attached to this e-mail. The table "gallery_element" have 8644 rows, and it have got 25932 registers. The machine has 512 Mb RAM and 1.4 PIV processor. Thank you very much. -- Manuel Trujillo [

[ADMIN] compression -Fx "problem"

rning" like this: Archiver: WARNING - requested compression not available in this installation - archive will be uncompressed What I make to do for obtain the necessary compression for the "-Fc" flag and work after with pg_restore? Thank you very much. Have a nice day ;-) TooManyS

Re: [ADMIN] table test

On Wed, Nov 28, 2001 at 10:53:45AM +0100, Manuel Trujillo wrote: Please, anybody can help me with this :((( > Hi. > > I need to know howto make a test for know the best accuracy of two types of tables: > 1- a table with three fields, and with seven registers or more, and >

Re: [ADMIN] table test

field contain BLOB's, only character data. Is only to know if, for table design, is more fastest one or another... Sorry if I can't explain more, but my english is very bad, and the information I know, is this :( -- Manuel Trujillo [EMAIL PROTECTED] Technical Engineer

[ADMIN] problems with pg_sorttemp

Hi. Excuse me my ignorance, but I have a problem with the ../data/base/xxx/pg_sorttempxxx.x. About 7.4 G of file utilization of this files. Anybody can help me for look documentation about this, or directly, tell me why occur this? Thank you very much. -- Manuel Trujillo [EMAIL

[ADMIN] problem with pg_sorttemp files

n a mistake :( Thank you very much. -- Manuel Trujillo [EMAIL PROTECTED] Technical Engineer http://www.motograndprix.com Dorna Sports S.L. +34 93 4702864 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appr

Re: [ADMIN] dumping users objects

make a \d{p|S|l} (list permissions/system tables/objects, you could solve your litle problem. If you make a small shell script, you could obtain a nice report about this information. The \dt option, also make the same effect (more or less). Have a nice day ;-) TooManySecrets -- Manuel Trujillo

Re: [ADMIN] Maximum Performance

ocessor, so the more processors u > have the more backends u can run at once > hope it helps Yes, but... How can I know the exact size of my database? And, if I compile the postgresql under four processors, don't work like (or in a) SMP, distributing the charge into the four pro

[ADMIN] starting log problems

Hi. I've got compiled a postgresql-7.1.3 into a Debian Sid box (linux). All works fine, but sometimes, when I go to look the log, this is set to "zero", is empty. The postgresql don't write anything into it file. I don't know if it occurs when stop-start postgres, or has any problem, or... well,

Re: [ADMIN] pg_restore

his backup (I think). Have a nice day ;-) TooManySecrets -- Manuel Trujillo [EMAIL PROTECTED] Technical Engineer http://www.motograndprix.com Dorna Sports S.L. +34 93 4702864 ---(end of broadcast)--- TIP 3: if posting/read

[ADMIN] stopping "wal"

wal make a "recover of processes", returning to the last situation. I would like to know how to "say" to postmaster don't make a "recover" from the wal files. Sorry for this explanation, but my english is very poor... :( Thank you very much. Have a nice day ;-) TooMa

Re: [ADMIN] stopping "wal"

t=192.168.141.208 user=xxx database=example And make this, to 20 backend processes!!. Tom say me to run "initdb", but... If possible to clean this wal's??? Thank you very much from here to Tom and the rest of pg-admin people. Regards, Manuel. -- Manue

[ADMIN] Locale support

h language, for example, and I need when a make a query to database, with PHP, the results are in japanish. Can the database make this directly, or I need to make this via php programation, making a php connection with postgres with the appropiate arguments? Thank you very much. -- Manuel Trujillo

Re: [ADMIN] hanging psql session while granting...

r a table, or tables, I use this: psql name_of_you_database < kk.sql | sed -e '1,3d' | awk '{print "GRANT "$priv" ON "$1" TO "$user";"}'>gdornaout psql motograndprix < gdornaout You need to set $priv (privileges), $user (affected

[ADMIN] problems with enconding (another...)

ossible to change the encoding. Anybody can help me, please? Thank you very much. -- Manuel Trujillo [EMAIL PROTECTED] Technical Engineer http://www.motograndprix.com Dorna Sports S.L. +34 93 4702864 ---(end of broadcast)

[ADMIN] moving tables and views

Hi. How can I move a view from a database X to database Y?? And, when a copy one or two tables, from one database to another, whith pg_dump, and I'm not putting the "-o" option, why preserve the oid's if I don't want it? Thank you very much. -- Manuel Trujillo

[ADMIN] problems with PgAdmin and database encoding.

a field of any table. This is the error of the log: ERROR: Unicode >= 0x1 is not supoorted This error is reported when she make a "cut&paste" of information from a microsoft word document, and cut this into the table. The postgresql version is 7.2. Anybody can help me plea

[ADMIN] Log's stopped.

On Fri, 2002-03-01 at 22:16, Tom Lane wrote: > Is the vacuum actually running (accumulating any CPU time)? Or is it > just waiting on a lock held by one of those other guys? > And what are they doing --- who started them, what query was sent to > 'em, etc? > If you haven't a clue, try attaching t

[ADMIN] config new server (problems with email server)

Hi. Sorry for that duplicated e-mail, but I think we have any problem with the e-mail server. I've a new server to put the database production. The characterictics of the new server are: 4 cpu's INTEL 1Ghz. 4 Gb. RAM My database is about 125-130 Mb of size, and I think this configuration for the