Diego Schulz escribió:
Hi,
Schemas are a lot like directories at operating system level (except
that can't be nested).
When you ls (or dir) in /home/martin/ , normally you don't expect to
see /home/johnny/ listed as well.
But if you really want to see all tables, try adjusting search_pa
I was making some table creation on one of our development DB and found
that psql's \dt has problems showing all tables available. Basically, if
you have to tables with the same name in different schemas, only one
will be listed (the one on the schema that is first in the search_path).
IMHO, \
Daneel escribió:
Daneel wrote:
While going through
http://wiki.postgresql.org/wiki/Detailed_installation_guides
and typing
service postgresql start
as root I got
"/var/lib/pgsql/data is missing. Use "service postgresql initdb" to
initialize the cluster first."
When I run
service postgresql i
Daneel escribió:
While going through
http://wiki.postgresql.org/wiki/Detailed_installation_guides
and typing
service postgresql start
as root I got
"/var/lib/pgsql/data is missing. Use "service postgresql initdb" to
initialize the cluster first."
When I run
service postgresql initdb
I get
"se
Please, can someone explain how is it posible for ALTER TABLE to add a
primary key column to a table without some intruction that would make it
a real PK (NOT NULL and UNIQUE).
prueba=> CREATE TABLE nopk (
prueba(> textito varchar
prueba(> );
CREATE TABLE
prueba=> INSERT INTO nopk VALUES ('algo
I'm doing some tests with Slony-I on 2 PG 8.3 servers (Debian testing)
and I stumbled with some issues related to the Slony docs (from the
slony.info page).
For example, I configured /etc/slony1/prueba/slon.conf and
/etc/slony1/slon_tools.conf correctly to replicate three tables I have
in the
Dan Armbrust escribió:
I got a warning from PostgreSQL 8.3.1 that said something to the effect of
checkpoints are happening to frequently... (-2484 seconds)
That part that confused me was the "-2484". Is that just a hyphen in
a strange place? Or did it really calculate a negative value?
Is t
I have a question related to the archive_command option of postgresql.conf.
In the documentation[1] I found examples that add a "< /dev/null" at the
end of the cp command. I know what the redirection from /dev/null does
(send an EOF), but is it really needed? In [2] there are examples that
don
Jeff escribió:
On Apr 26, 2008, at 8:40 AM, Martin Marques wrote:
Martin Marques escribió:
I'm re-writing documentation I have used in the past to give PG
courses, and at this moment I upgrading the information in my docs to
fit PG 8.3.
What I'm stuck with now is pgiomonitor, whic
Tom Lane escribió:
Martin Marques <[EMAIL PROTECTED]> writes:
How much, and which extra statistics information will ANALYZE gather if
I set a higher value for one specific column (maybe one with and index,
and heavily used in SELECT clauses)? If instead of 100 I set a column to
250,
I'm trying to understand the implications of changing the value of the
STATISTICS of a column with ALTER TABLE, and there are somethings I'm
not understanding correctly.
How much, and which extra statistics information will ANALYZE gather if
I set a higher value for one specific column (maybe
Martin Marques escribió:
I'm re-writing documentation I have used in the past to give PG courses,
and at this moment I upgrading the information in my docs to fit PG 8.3.
What I'm stuck with now is pgiomonitor, which seems to not work due to
the changes that happened between 8.1 (l
I'm re-writing documentation I have used in the past to give PG courses,
and at this moment I upgrading the information in my docs to fit PG 8.3.
What I'm stuck with now is pgiomonitor, which seems to not work due to
the changes that happened between 8.1 (last time I used it) and 8.3.
Does an
Greg Smith escribió:
> On Sat, 1 Dec 2007, Tomasz Ostrowski wrote:
>
>> You can also use "hdparm -I" to check this - look for a "Write
>> caching" in "Commands/features" section. If it has a "*" in front
>> then it is enabled and dangerous.
>
> Right; using -I works with most Linux hdparm version
Joshua D. Drake escribió:
On Sat, 01 Dec 2007 15:22:38 -0500
I wonder what I'm supposed to do with my debian installation since
there doesn't seem to be any such thing as pg_resetxlog. Or is it
hiding somewhere?
I don't recall if it is in contrib or not.. try?:
apt-file is your friend:
apt
Tom Allison escribió:
I wonder what I'm supposed to do with my debian installation since there
doesn't seem to be any such thing as pg_resetxlog. Or is it hiding
somewhere?
On one debian I have:
/usr/lib/postgresql/8.1/bin/pg_resetxlog
/usr/lib/postgresql/8.2/bin/pg_resetxlog
---
Tomasz Ostrowski escribió:
On Sat, 01 Dec 2007, rihad wrote:
fsync = on;
synchronous_commit = off;
full_page_writes = off;
Thanks for any insights or clarifying missed points.
Also check whether a disks have write-caching turned off - it should.
On Linux the command is:
# hdparm -W /d
Alvaro Herrera wrote:
It's an arbitrary number, based on which all the other numbers are
measured.
Now that I read more intensively he docs I see that all the cost
parameters are related one with the other.
What people generally do around here is mess with random_page_cost, and
leave seq_p
Martin Marques escribió:
Pavel Stehule wrote:
try
set work_mem to '8MB';
and
explain analyze select ..
These things didn't help. What changed the plan completely was this:
seq_page_cost = 5.0 # measured on an arbitrary scale
cpu_tu
Pavel Stehule wrote:
2007/10/22, Martin Marques <[EMAIL PROTECTED]>:
Pavel Stehule wrote:
2007/10/22, Martin Marques <[EMAIL PROTECTED]>:
Pavel Stehule wrote:
Hello
I am unsure, did you check config values?
Don't know which ones you are talking about, but all enabl
Tomas Vondra wrote:
2007/10/22, Martin Marques <[EMAIL PROTECTED]>:
Pavel Stehule wrote:
Hello
I am unsure, did you check config values?
Don't know which ones you are talking about, but all enable_* are set
to on.
Anything else?
shared_buffers
work_mem
effective_cache_
Pavel Stehule wrote:
2007/10/22, Martin Marques <[EMAIL PROTECTED]>:
Pavel Stehule wrote:
Hello
I am unsure, did you check config values?
Don't know which ones you are talking about, but all enable_* are set to on.
Anything else?
shared_buffers
8.1:
16000
8.2:
400MB
Pavel Stehule wrote:
Hello
I am unsure, did you check config values?
Don't know which ones you are talking about, but all enable_* are set to on.
Anything else?
--
21:50:04 up 2 days, 9:07, 0 users, load average: 0.92, 0.37, 0.18
-
I have to PG servers, one ver. 8.1.9 and the other 8.2.4.
I was checking a query out and found that with the exact same DB (same
data in it) and the same query I get different plans, and significantly
higher time in 8.2:
On 8.1 I get:
test=> explain analyze SELECT * FROM prestamos WHERE bibl
We are at the moment planning on passing some passwords that are plain
texted in our DB to some encrypted form as now they will be used for
processes that require better security measures.
We started looking at md5() but found that it's easy to crack and one of
the systems uses CHAP authentica
Johann Maar wrote:
Hi folks,
sorry I do not get it right and I have to ask now.
I manually compiled PostgreSQL on my Kubuntu machine to /usr/local/opt/
pgsql and did all this stuff like creating a "postgres" user and I
have a startup script in /etc/init.d.
But if I try to start PostgreSQL by ru
Albe Laurenz wrote:
[2]:
http://www.postgresql.org/docs/8.1/interactive/functions-string.html#FTN.AEN7625
Well, the documentation for to_ascii states clearly:
"The to_ascii function supports conversion from LATIN1, LATIN2,
LATIN9, and WIN1250 encodings only."
Sorry, didn't see the footn
LEGEAY Jérôme wrote:
for convert my DB, i use this process:
createdb -T "old_DB" "copy_old_DB"
dropdb "old_DB"
createdb -E LATIN1 -T "copy_old_DB" "new_DB_name"
maybe this process will help you.
As I said in my original mail, the DB conversion went OK, but I see some
discrepancies in the do
I have a doubt about the function to_ascii() and what the documentation
says.
Basically, I passed my DB from latin1 to UTF-8, and I started getting an
error when using the to_ascii() function on a field of one of my DB [1]:
ERROR: la conversión de codificación de UTF8 a ASCII no está soporta
On Tue, 27 Dec 2005, dfx wrote:
Dear Sirs,
I have a little problem:
- Contest: Server side: Linux Fedora core 4 with PostgreSQL v. 8.0
Client side: both Linux Fedora core 4 with pgAdmin III v.
1.4 and/or Windows 2000 server vith pgAdmin III v. 1.4
- I Made a table:
CREATE TABL
On Mon, 26 Dec 2005, Tom Lane wrote:
This might be a good time to press your buddy to move to 8.1 ;-)
PG 8.1 contains logic that should positively prevent a wraparound, by
shutting down the server if wraparound gets too close.
But if VACUUM fixes the wraparound issue, shouldn't even a badly
c
On Thu, 15 Dec 2005, Tom Lane wrote:
Michelle Konzack <[EMAIL PROTECTED]> writes:
Please note, that I use "hostssl" only.
You might have forgotten to set up the SSL key files?
I'm having some trouble with a 8.0 on Debian on Intel. My development
SPARC version works OK with SSL connections.
On Wed, 19 Oct 2005, Christopher Kings-Lynne wrote:
If there smart enough to be buying innobase these days, you can bet that
by now they have this stuff all straightened out.
No, that doesn't seem to follow ... if Oracle are spending their
resources to attack MySQL rather than us, the conclu
El Vie 02 Jul 2004 18:39, Jan Wieck escribió:
> On 6/22/2004 11:51 PM, mike g wrote:
> > Slony version 1 is supposed to be live very soon. You can test beta3 if
> > you like.
>
> Slony-I version 1.0 is out now. It does not contain incremental backup.
> This feature is on the TODO list for 1.1.
I'
El Jue 10 Jun 2004 22:14, escribió:
> Hi,
>
> we are using Postgres with a J2EE application (JBoss) and get
> intermittent "out of memory" errors on the Postgres database. We are
> running on a fairly large Linux server (Dual 3GHz, 2GB Ram) with the
> following parameters:
>
> shared_buffers = 8192
El Vie 30 Abr 2004 11:16, Thomas LeBlanc escribió:
> What are the SQL commands to find who is logged on a server, what database
> he/she has open, etc?
>
> Where is this information in the help file or documentation?
select * from pg_stat_activity;
--
11:47:01 up 1 day, 17:09, 3 users, load a
El Mié 14 Abr 2004 22:22, Christopher Kings-Lynne escribió:
> > ... on projects.postgresql.org, or similar.They really aren't doing
> > any good in /contrib.
> >
> > I've already set up a category "conversion tools" on pgFoundry, and my
> > idea was one project per target system.
>
> I reckon t
I'm building some functions in plpgsql, and I got to a point where I thought:
How are transactions used in the function? Is it posible to rollback the
modifications that were made to the tables at some point in the plpgsql
function?
--
09:58:01 up 10 days, 14:29, 4 users, load average: 0.11
El Jue 29 Ene 2004 16:26, Barbara Lindsey escribió:
> What permission does a user need to have to query the pg_ tables
> (pg_attribute, pg_class, etc) ? Do they require special permissions?
What kind of queries? Read or Write?
Users have permission to read from most catalog tables. One they can'
I was reading the section about Planner Method Configuration, and I just don't
get why all the options have this message: "This is used for debugging the
query planner". Are they all debugging options, because they don't look like.
http://www.postgresql.org/docs/current/interactive/
-> runti
Mensaje citado por Doug McNaught <[EMAIL PROTECTED]>:
> "Ruby Deepdelver" <[EMAIL PROTECTED]> writes:
>
> > Hello, I'm having trouble in find certain information, i've search
> > over the web and through the documentation but i haven't had lucky.
> > I need to know if there is some limit in the a
Mensaje citado por "Joshua D. Drake" <[EMAIL PROTECTED]>:
>
> >I used to have that complaint until I got more aquainted with the docs.
> >When I used to use mysql I found that if I used search feature on their
> docs
> >I could find exactly what I was looking for almost immediately. When I use
>
Mensaje citado por Matt Davies <[EMAIL PROTECTED]>:
> Quoting "Joshua D. Drake" <[EMAIL PROTECTED]>:
>
> > >
> > MySQL has what 19 million in the bank?
>
> I only point out what the userbase is feeling. I have never been attacked as
> an
> idiot when using MySQL - I have always had helpful resp
Mensaje citado por Ben <[EMAIL PROTECTED]>:
> On Wed, 14 Jan 2004, Joshua D. Drake wrote:
>
> > Not to mention that PostgreSQL.Org has some of the most complete
> > documentation
> > of any software out there.
>
> Yes, I don't understand why people seem to keep complaining about
> Postgres' do
El Mar 30 Dic 2003 04:07, B. van Ouwerkerk escribió:
> >Does it say that there is a limit? Yes surely there is one, which most
> > likely will depends on the Processor and OS you are running (64 bit or 32
> > bit), but anyway, such log varchars wouldn't be that recommended, and
> > maybe the TEXT d
El Mar 30 Dic 2003 02:49, Bret Busby escribió:
> On Mon, 29 Dec 2003, Martin Marques wrote:
> >
> > At this point, the book makes the following assumptions:
> >
> > * You have installed POSTGRESQL.
> > * You have a running POSTGRESQL server.
> >
El Vie 26 Dic 2003 20:10, Randal L. Schwartz escribió:
> >>>>> "Martin" == Martin Marques <[EMAIL PROTECTED]> writes:
>
> Martin> A link to the URL above in the SELECT page?
>
> Uh, do you also want a link to "installing PostgreSQL" th
El Vie 26 Dic 2003 18:27, Tom Lane escribió:
> Mike Nolan <[EMAIL PROTECTED]> writes:
> > It took me less time with the Oracle SQL Language Reference Manual, but
> > I cheated by looking it up in the index.
>
> Just FYI, there's an index entry for BETWEEN in the PG docs too:
> http://www.postgresq
El Vie 26 Dic 2003 18:02, Mike Nolan escribió:
> > Damn, didn't find it in the docs, and just supposed it wasn't there.
>
> Try finding it in the online mysql docs. :-)
>
> Yes, it is there, but it took me far longer to wade through their
> docs to find it than in the postgresql docs.
>
> It
El Vie 26 Dic 2003 16:26, escribió:
> Martin Marques <[EMAIL PROTECTED]> writes:
> >> That's been in PostgreSQL for a long time.
>
> > Damn, didn't find it in the docs, and just supposed it wasn't there.
>
> It's been shown on the &
El Vie 26 Dic 2003 13:18, Sai Hertz And Control Systems escribió:
> Dear Martin Marques,
>
> >>What do you think yes we PostgreSQL users need some introspection.
> >>
> >>
> >
> >1) This is in the 5.0.0 development tree, which could come out
El Vie 26 Dic 2003 13:02, Mike Nolan escribió:
> > Is there any chance on supporting BETWEEN in the WHERE conditions of a
SELECT
> > clause?
>
> You mean like this?
>
> Welcome to psql 7.4.1, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for hel
El Sáb 13 Dic 2003 16:21, MT escribió:
> Hi,
>
> I have an invoicing system using postgresql. Each time a customer makes a
purchase, a new record is inserted into the "cart" table. The "cart" table,
among other things, contains a customer_id field and a total for the amount
purchased on the par
El Dom 07 Dic 2003 17:10, Doug McNaught escribió:
> Martin Marques <[EMAIL PROTECTED]> writes:
>
> > Is the postgres super-user the only one that can create functions
> > with LANGUAGE C?
>
> Yes, because a C function can basically do anything it wants to with
>
I'm trying to load the pgcypto.sql file from the contrib in a database and
I've hit a problem which I never had in the past (maybe never did it this
way): when I try to load this file (psql -f) with a specific user, which is
not the postgres super-user I get a permission denied, and couldn't fin
El Vie 28 Nov 2003 10:38, Chris Travers escribió:
> One thing that I always have to remind myself of is this:
>
> string || NULL is NULL.
> It is usually a good idea to use coalesce() unless you want this to happen.
Pretty nice. :-)
Even though I don't have that problem, becuase the value comes f
El Sáb 22 Nov 2003 20:07, CSN escribió:
> Is there an updated version of Lamar Owen's linux
> startup script available? It initializes the database
> on first invocation after initdb has been done
> manually (even after changing all 7.3's to 7.4's in
> the script), then gives an error on subsequent
El Sáb 22 Nov 2003 17:20, Patrick Hatcher escribió:
> Doing an upgrade on RH 8 box from 7.3.4 to 7.4 from source. The
> installation appeared go smoothly. I tried to reinstall my database using
> psql -d someda -f data.file and I get the error message:
> error while loading shared libraries: libp
El Dom 16 Nov 2003 16:56, escribió:
> Martin Marques <[EMAIL PROTECTED]> writes:
> > El Dom 16 Nov 2003 15:23, Tom Lane escribió:
> >> See sysctl. But what is the current value? I've never heard of a Linux
> >> installation with small SEMVMX.
>
>
El Dom 16 Nov 2003 15:23, Tom Lane escribió:
> Martin Marques <[EMAIL PROTECTED]> writes:
> > El Vie 14 Nov 2003 12:37, Tom Lane escribió:
> >> Hmm. If it got that far and no farther, I'd guess you have SEMVMX
> >> set too small.
>
> > Is ther
El Vie 14 Nov 2003 12:37, Tom Lane escribió:
> Martin Marques <[EMAIL PROTECTED]> writes:
> > creating template1 database in /usr/local/pgsql/data/base/1... FATAL:
> > semctl(1638435, 16, SETVAL, 536) failed: Argumento inválido
>
> Hmm. If it got that far and no
When running initdb on a fresh 7.4 install I get this error:
[EMAIL PROTECTED]:~$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data -E
latin1
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be
El Lun 10 Nov 2003 16:14, MaRcElO PeReIrA escribió:
> Hi guys,
>
> Do you know any web based bug tracker software that
> use PostgreSQL???
>
> Somebody has told me about Mantis, but it use MySQL...
> and I resign to use that! :(
>
> Which is the best bug tracker you
> know???(PHP+PostgreSQL)
Wa
El Jue 23 Oct 2003 19:41, Chris M. Gamble escribió:
> I am trying to perform what I best understand as Multi-master asynchronous
replication for postgres 7.3.3 servers. After researching, I tried the
pgReplication project (and made the simple modification as listed in their
mailing lists), but w
sistema operativo es aquel que te da de comer.
Cuida tu dieta.
---------
Martin Marques |[EMAIL PROTECTED]
Programador, Administrador | Centro de Telematica
We are trying to make some things work with plpgsql. The problem is that I
built several functions that call one another, and I thought that the way of
calling it was just making the assign:
var:=func1(arg1,arg2);
which gave me an error near ")".
Now if I did the same, but like this:
PERFORM
El Lun 13 Oct 2003 11:38, Tom Lane escribió:
> Alex <[EMAIL PROTECTED]> writes:
> > The LD_LIBRARY_PATH actually points to the library, I am even able to
> > execute the initdb but the postmaster always fails
>
> In that case, almost certainly, the environment you are starting the
> postmaster in i
El Dom 05 Oct 2003 07:20, Peter Eisentraut escribió:
> Jillian Carroll writes:
> > As your new PostgreSQL "Master of Ceremonies",
>
> What?
Looks pretty cool! :-)
By the way, I was exposing in the last Conferences of GNU/Linux and Open
Source Software here in Santa Fe Argentina, about RDBMS and
El Jue 02 Oct 2003 04:24, Thierry Missimilly escribió:
> I've try the trail version of PostgreSQL Manager by EMS
> http://www.ems-hitec.com/pgmanager . But it is not free but not very
> expensive (aboot 200$). It is a good tools.
>
> I've try PgAdmin III on Windows 2000 . It's very good and free.
>
El Mié 01 Oct 2003 19:58, Rick Seeger escribió:
> We're looking for a (preferrably free) Windows (or browser) based PG
> admin tool to use in our office. I've only ever used the psql command
> line interface, so I don't have any experience with the GUI tools out
> there. Any help appreciated.
>Fro
This scripts don't do the job completly, but give you a boost. I normally pass
my MySQL dumps throught these scripts and then open them with my editor and
do the changes that were missing.
You will always have to make changes in things like MySQLs inconsistencys
(dates that don't exist, an so o
El Jue 18 Sep 2003 20:34, scott.marlowe escribió:
>
> they still claim to have ACID compliance, an issue I've discussed with a
> few of the folks from MySQL AB. To them, the C in ACID only implies fk
> constraints. The fact that they ignore base type constraints (i.e. insert
> 8 billion into an i
El Dom 14 Sep 2003 12:20, Lincoln Yeoh escribió:
> >At 07:16 PM 9/13/2003 -0400, Lamar Owen wrote:
> >'migration' server. And I really don't want to think about dump/restore
> >of 100TB (if PostgreSQL actually stores the image files, which it might).
>
> Hmm. Just curious, do people generally back
El Vie 12 Sep 2003 16:22, Duffey, Kevin escribió:
> I don't know if jdbc/java code requires this, but when I use two gui admin
> tools I found, and I insert a row into the table using their row editor
> feature, both require me to enter a number for the Serial type. I thought
> this type was used t
El Jue 28 Ago 2003 10:26, Benjamin Jury escribió:
> The only problem with 'Practical PostgreSQL' is that it is rather out of
> date.
Not exactly. Yesterday a friend told me that a new edition of the book was
coming out this month, which should cover up to 7.3, or even 7.4 features.
Any way, I wa
On Vie 04 Jul 2003 03:52, Weiping He wrote:
> Hi, all,
>
> I've met a wierd problem on a Solaris 8/sparc box with postgresql
> 7.3.3:
>
> the server would automatically shutdown after a period of time of
> not operating. The log show something like this:
>
> pmdie 2
>
> anybody usin
On Mar 01 Jul 2003 10:11, Andrew Gould wrote:
> Are you using advanced authentication in phppgadmin?
>
> Could this be caused when phppgadmin is configured to
> have the database superuser connect to template1 to
> manage user logins?
phpPgAdmin has nothing to do, now that I made some tests.
1) I
OK, the picture is the latest CVS of phpPgAdmin on PostgreSQl 7.3.1.
I created a user with createDB option. Here OK.
I connect to phpPgAdmin as that user and try to create a DB and I get this
error:
Error de SQL:
ERROR: CREATE DATABASE: source database "template1" is being accessed by
other u
78 matches
Mail list logo
