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
activity!!) I can not maintain this amount of data to
performs future WAL backups and recovers.
Any idea to decrease the number of WAL segments generated?
Is possible to know when a table would be reindexed and to avoid dayly
REINDEX process?
Thank you.
Jose Manuel García V.
begin:vcard
fn
--
Todos somos muy ignorantes, lo que ocurre es que no todos ignoramos las
mismas cosas.
—Albert Einstein
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Ben Kim <[EMAIL PROTECTED]> writes:
> Manuel Sugawara wrote:
> >> Is there a way to completely turn off case sensitivity of the names
> >> of table, field, sequence, etc.?
> >No, i'm afraid not. But you can tweak scan.l to teach postgreSQL do
> >what
Terry Hampton <[EMAIL PROTECTED]> writes:
> Manuel,
>
> Many thanks for your quick reply. When I
> enter: SELECT * FROM pg_type where typname='varchar';
>
>I get:
>
> typname | typowner | typlen | typprtlen | typbyval | typtyp
Terry Hampton <[EMAIL PROTECTED]> writes:
> I can't determine what SQL to which system catalog will associate
> "1043" to "varchar" and "25" to "text"
pg_type where oid = 1043, ie:
SELECT * FROM pg_type WHERE oid = 1043;
Regar
"Jaime Casanova" <[EMAIL PROTECTED]> writes:
> I was thinking about using postgresql and want to know if i can use
> raw devices with it?
No it's not possible, postgreSQL uses whatever filessystem the os
provides.
Regards,
Manuel.
-
Ben Kim <[EMAIL PROTECTED]> writes:
> Dear List,
>
> Is there a way to completely turn off case sensitivity of the names
> of table, field, sequence, etc.?
No, i'm afraid not. But you can tweak scan.l to teach postgreSQL do
what you want.
Regards,
Manuel.
---
another user
psql -U bruce -d movies
Read the psql(1) and createuser(1) manual pages for details.
Regards,
Manuel.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
correct one (may be
en_US). Same for the others lc_* variables.
Regards,
Manuel.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ut those
commands in your .psqlrc file and psql will read it each time it's
invoked. See psql(1) for details.
Regards,
Manuel.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
y I used the zip format - it always seems to come out smaller by at
> least a factor of 2.
Really?, Mine is smaller:
[EMAIL PROTECTED] ls -l citext.*
-rw-r--r--1 masm masm 7334 sep 25 17:00 citext.zip
-rw-r--r--1 masm masm 7147 sep 25 18:12 citext.tar.gz
[
portable for C programs and should be changed and (2) the standard way
to distribute this kind of stuff is a tarball, zip is more from the
windows world.
Regargs,
Manuel.
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
I want to know if there are companies than bring
support of PostgreSQL.
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
---(end of broadcast)---
TIP 4: Do
"Chad R. Larson" <[EMAIL PROTECTED]> writes:
> At 01:31 PM 5/26/02 , Manuel Sugawara wrote:
> >-RAID (5+0) A logical volume with several RAID 3 logical member
> >drives.
>
> Perhaps a typo?
Yes :-(
Regards,
Manuel.
---(end of broa
ok" from the RAID Advisory Board.
Regards,
Manuel.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
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
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
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
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
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)
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
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
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
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
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
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,
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
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
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
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
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.
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
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 [
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
|||
> > >
> > >
> > > 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
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
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
>
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
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
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'
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?
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
it would crearte
>> the database = with all the tables and everything. Can anyone please help
>> me with this? Thanks in advance,
>
> Look programm:
> pg_dump
> pg_dumpall
> psql
>
>
Use pg_dump.
pg_dump >
createdb
cat | psql
--
Man
44 matches
Mail list logo
