Hi,
I got this little problem creating users:
I want to connect to my db with a new user and I must create it like if he
was a superuser, otherwise I can not conncet to my database.
Could some body help me
Thanks a lot
Alvaro
---(end of broadcast
d because of error
pg_dumpall: pg_dump failed on dbsa, exiting
How can I solve this problem?
How can I tell what is the OID 102548365? is it related to an index or a
table or what?
I search the web looking for answers to these questions but I cludn't find
them.
ed the max_connections to 150
(/var/lib/pgsql/data/postgresql.conf), could this be the the source of the
problem???.
Thanks a lot for your help. I'm sorry to bother you but your the only one
"I know" that knows more about Postgresql than I (I'm l
Mr. Szabo this is part of the output of the vacuumdb command
DETAIL: dead row versions cannot be removed yet.
There were unused item pointers.
pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.02 sec.
INFO: vacuuming "public.tbl_fact_consumos"
INFO: index "ind_fact_consumos" now
have to recover the schema and then all the data...?
I know that maybe this not a big deal because in the worst case I can
create the Indexes and constraints manually, but I really want to know why
is that? Am I donig things wrong..?
I hope you can help me...
Thanks for taking some of y
7;t exist but I
restart postmaster several times and postmaster still iniocates that
condition how can I fix this?
Thanks a lot for your help,
Alvaro
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
n undo the resetxlog operation -Please say yes...-
Thanks a lot,
Alvaro
Thanks a lot for your help,
Alvaro
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
the hardware plataform is roboust (I guess)
Dell power edge 6600, 16Gb RAM, SCSI RAID 5 (200Gb total), 4 cpus.
Do you think that this values a correct or maybe one of those are the
origin of the problem...?
Thanks in advance,
Alvaro
---(end of broad
immediately, by now the error reported by the postgresql server
does not appear anymore.
Special Thanks to Mr. Tom Lane for your concern since we post a message
for first time.
Alvaro
alvaro ( at ) audifarma ( dot ) com ( dot ) co writes:
> I'm having some strange problem with a server po
ou could check the information_schema. See the
docs on "system catalogs" in the Internals chapter.
--
Alvaro Herrera (<[EMAIL PROTECTED]>)
"Escucha y olvidarás; ve y recordarás; haz y entenderás" (Confucio)
---(end of broadcast)
7;s no "developer" versions of Postgres. With the free version you
get all capabilities.
> For our application it may run as client server
> application may be of 10 concurrent users,with 40
> tables of 1 rows for 2 r 3 tables and others
> mostly of 1000 rows.
Pos
On Wed, Apr 27, 2005 at 02:02:09PM -0400, Mario Soto Cordones wrote:
> with this query I obtain the schema name and the objects of this it , but
> like I can know that they are, that is to say if they are tables,
> views, functions, sequences, etc
See pg_class.relkind.
-
der by tipo desc
Why are you using a group by here? It's unnecesary.
> but not you where they stay the functions
See the pg_proc catalog.
I wonder if I have pointed you to the documentation before? See the
"system catalogs" section in the internals chapter. Also, maybe you
( Specially when the receiving account is no
longer available -- the list owner starts getting bounces from an
account he can't unsubscribe, and it's hard to track down who of the
whole list is forwarding to the bogus account.
--
Alvaro Herrera (<[EMAIL PROTECTED]>)
"La trist
rt of nuking everything and
> restoring from a backup dump? :-(
Connect in standalone mode?
--
Alvaro Herrera (<[EMAIL PROTECTED]>)
"Ellos andaban todos desnudos como su madre los parió, y también las mujeres,
aunque no vi más que una, harto moza, y todos los que yo vi eran todos
mancebos,
efully in 8.1 you will be told where the
user/group is referenced if you try to drop it. Automatically deleting
the references from all ACLs has not been discussed but it's a possible
outcome of the implementation.
--
Alvaro Herrera ()
"And as an added bonus, now my computer goes to th
On Fri, May 13, 2005 at 10:48:13PM -0400, Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > We are working on it, and hopefully in 8.1 you will be told where the
> > user/group is referenced if you try to drop it. Automatically deleting
> > the references
and improvements most welcome.
You could change all those "CASE WHEN foo IS NULL THEN 0 ELSE foo" into
COALESCE(foo, 0).
Additionally, "show block_size" will give you the block (page) size. I
don't see how would you use that in a query though.
--
Alvaro Herrera
/tablecmds.c (DefineRelation I think)
This question is not on-topic in pgsql-admin anyway; you should be
asking on -hackers, I think.
Also, the name of the server is PostgreSQL; shortened to Postgres by
historic reasons, to PgSQL sometimes, and even Pg. I haven't ever seen
nobody use "pgs".
--
rrent_setting
-
on
(1 fila)
--
Alvaro Herrera ()
La web junta la gente porque no importa que clase de mutante sexual seas,
tienes millones de posibles parejas. Pon "buscar gente que tengan sexo con
ciervos incendiándose", y el computador dirá "especifique el tipo
on the
size of the keys. You can find out for a particular index using
pg_filedump too.
--
Alvaro Herrera ()
Jude: I wish humans laid eggs
Ringlord: Why would you want humans to lay eggs?
Jude: So I can eat them
---(end of broadcast)---
TIP 2: you
On Wed, Jun 08, 2005 at 07:04:17AM -0600, Eduardo Bezerra wrote:
> Sorry,
>
> But, where can I find out this utility? Is it pg_dump?
No, see in http://sources.redhat.com/rhdb or thereabouts (maybe
http://sources.redhat.com/RHDB even, not sure)
--
Alvaro Herrera ()
"Puedes vivi
the selected column name for the
> old.columnName/new.columnName?
Standard answer has been "can't do that in plpgsql". You may want to
try pl/perl, pl/python (does that support triggers?) or pl/tcl.
If performance is an issue, write the function in C.
--
Alvaro Herrera ()
"If it w
... hmm, it says it has triggers
> -> try to open pg_trigger to read triggers
>
> ... recurse until out of stack space.
IIRC Joe Conway had this problem some time ago, and he managed to get
out of it. I don't recall details, maybe searching the
you further
advice. Going forward, rtree is somewhat obsolete -- maybe try setting
up a GiST index instead (not sure if it would be faster than rtree.)
--
Alvaro Herrera ()
"God is real, unless declared as int"
---(end of broadcast)---
lues from functions are never cached at all, not even for
immutable functions. The mutability flag (currently) is only used for
deciding the "optimizability" of the function within the query's
execution.
--
Alvaro Herrera ()
"El que vive para el futuro es un iluso, y el que vi
n if someone stepped up and programmed a decent
> table partitioning patch. I have a feeling it's one of the things on
> the TODO list that will happen in the next version or two.
I think Simon Riggs and crew are working on this.
--
Alvaro Herrera ()
Jude: I wish humans l
una lista en ingles. Para hacer preguntas en castellano te
sugiero la lista pgsql-es-ayuda en este mismo servidor.
Con respecto a tu pregunta, si, PostgreSQL tiene automaticamente en
cuenta el numero de procesadores (mejor dicho, le deja esta tarea al
sistema operativo).
--
Alvaro Herrera ()
&q
ch are "yes" and "if" respectively, but it
didn't note that I voluntarily made a typo :-)
--
Alvaro Herrera ()
"Someone said that it is at least an order of magnitude more work to do
production software than a prototype. I think he is wrong by at least
a
On Mon, Jul 11, 2005 at 02:20:52PM -0600, Lee Wu wrote:
> Here is my test, I think the privilege should be revoked automatically.
Long-standing known bug. Fixed in 8.1.
--
Alvaro Herrera ()
"La persona que no quería pecar / estaba obligada a sentarse
en duras y empinada
e to convert
> back to the original value.
Wow, incredible. You misread the whole documentation.
--
Alvaro Herrera ()
"We are who we choose to be", sang the goldfinch
when the sun is high (Sandman)
---(end of broadcast)
gt; transaction IDs in shared catalogs.)
I wonder if this restriction could be lifted if we tracked last-vacuum-
Xid per relation?
--
Alvaro Herrera ()
"Cuando mañana llegue pelearemos segun lo que mañana exija" (Mowgli)
---(end of broadcast)-
notify mechanism.
--
Alvaro Herrera ()
"Find a bug in a program, and fix it, and the program will work today.
Show the program how to find and fix a bug, and the program
will work forever" (Oliver Silfridge)
---(end of broadcast)---
TIP 9: In ve
y.info
--
Alvaro Herrera ()
"There is evil in the world. There are dark, awful things. Occasionally, we get
a glimpse of them. But there are dark corners; horrors almost impossible to
imagine... even in our worst nightmares." (Van Helsing, Dracula A.D. 1972)
---(
On Sat, Jul 30, 2005 at 02:59:30PM -0700, Chris Travers wrote:
> Also I wonder what the impact of several Postmasters trying to access
> data over NFS would be.
That will lead to corruption very quickly.
--
Alvaro Herrera ()
"Estoy de acuerdo contigo en que la verdad absoluta no e
ou try connecting with psql? Maybe your EMS client does not
support SSL (it'd surprise me.)
--
Alvaro Herrera ()
"Las cosas son buenas o malas segun las hace nuestra opinión" (Lisias)
---(end of broadcast)---
TIP 3: H
On Mon, Aug 08, 2005 at 12:24:14PM -0400, Mario Soto Cordones - Venezuela wrote:
> 2005/8/8, Alvaro Herrera <[EMAIL PROTECTED]>:
> > On Mon, Aug 08, 2005 at 11:41:24AM -0400, Mario Soto Cordones - Venezuela
> > wrote:
> > > LOG Say:
> > >
> > > L
E-RSA-AES256-SHA, bits: 256)
Ok, so it works with psql and the server is configured correctly.
Congratulations!
> 2005/8/8, Alvaro Herrera <[EMAIL PROTECTED]>:
>
> > Maybe you have to enable it explicitly? Maybe it's not supported in the
> > free (lite) version? Again, d
On Mon, Aug 08, 2005 at 12:40:24PM -0400, Alvaro Herrera wrote:
> On Mon, Aug 08, 2005 at 12:24:14PM -0400, Mario Soto Cordones - Venezuela
> wrote:
> > 2005/8/8, Alvaro Herrera <[EMAIL PROTECTED]>:
> >
> > > Yeah, the server thinks it's active, but the cli
here's no way a single conversion will get it right.
You will have to manually separate the parts that are UTF8 from the
Latin1, and import them separately. Not a position I'd like to be in.
--
Alvaro Herrera ()
"Coge la flor que hoy nace alegre, ufana. ¿Quién sab
d \, and escape them somehow.
There's another way, which is using new features of the v3 protocol.
One easy way to do that is using PQexecParams() instead of PQexec(), if
you are dealing with C programs.
--
Alvaro Herrera ()
"In a specialized industrial society, it would be a disaster
to
e "data" folder somewhere. Then start the postmaster
giving the -D option pointing to that directory.
--
Alvaro Herrera ()
"I would rather have GNU than GNOT." (ccchips, lwn.net/Articles/37595/)
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
t I still seem to see some log messages trickle through to the console. I
> assume these are appearing on stdout?
What messages?
--
Alvaro Herrera ()
Oh, oh, las chicas galacianas, lo harán por las perlas,
¡Y las de Arrakis por el agua! Pero si buscas damas
Que se consuman como llamas, ¡Prueba
What server version are you using? You can find out by
issuing
SELECT version();
--
Alvaro Herrera ()
One man's impedance mismatch is another man's layer of abstraction.
(Lincoln Yeoh)
---(end of broadcast)---
TIP 9: In versions below 8.0
on the
> recipient user.
>
> It is not at all intuitive that "GRANT ALL PRIVILEGES" gives a user the
> right to create schemas and temporary tables, and that alone.
If you have a suggestion for a better wording, please share -- there's
always room for improving the docu
g. The
space will not be recovered by any maintenance command.
--
Alvaro Herrera ()
Y dijo Dios: "Que sea Satanás, para que la gente no me culpe de todo a mí."
"Y que hayan abogados, para que la gente no culpe de todo a Satanás"
---(end of broadcast)-
If you want to recover to a time during the backup you have to
> use the previous backup and xlog files.
One important detail is that the system is able to detect whether a
change registered in WAL was already applied to the data files or not.
So if it's already applied, it doesn't need
you should consider setting the cost-based vacuum
nap options appropiately, so that the vacuum process does not impact on
I/O too much while running. Read the section of the fine manual about
"Cost-based vacuum delay"; I think it's in the "runtime configuration"
section.
--
On Mon, Aug 22, 2005 at 11:10:54AM -0300, Maxi Combina wrote:
[must run initdb to switch locale]
>
> Is there any shorter way to change the locales? I didnot found any
> `recreate' or `regenerate' command.
No, initdb is the only option.
--
Alvaro Herrera ()
"El número
may be checking table stats with pgstattuple. If the
percentage of dead rows grows as time passes, you have a problem.
--
Alvaro Herrera Architect, www.EnterpriseDB.com
"Puedes vivir solo una vez, pero si lo haces bien, una vez es suficiente"
---(end o
there is a section called "Disk
Storage" or something similar.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
"[PostgreSQL] is a great group; in my opinion it is THE best open source
development communities in existence anywhere."
On Fri, Sep 02, 2005 at 04:11:35PM -0400, Alain Rodriguez Arias wrote:
> Please,anybody can tell me how to make replication of a PostGre DB
Did you already look at Slony-I, www.slony.info ?
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
"I think my s
7;t doing the appropiate regular maintenance tasks.
Please have a look at the manual,
http://www.postgresql.org/docs/8.0/static/maintenance.html
For further performance tuning, have a look at
http://www.powerpostgresql.com/PerfList
--
Alvaro Herrera -- Valdivia, Chile Architect, www.Enterp
to work. I have restarted postgres, restarted windows,
> and it simply wont take..
Which program fails, and how does it fail?
You have the correct permissions on the file, I presume? The file
should not be readable nor writable by anyone but the owner; and I
assume the directory where it resi
xt beta.
(pltemplate being the other one.) We should set a threshold in order to
be able to decide ...
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
"Use it up, wear it out, make it do, or do without"
---(end of broadcast)--
ient_encoding to the encoding that the strings are encoded in. If
you choose the wrong client_encoding, the server may recode the
characters inappropiately, or not at all, and thus insert wrong data.
Please see the documentation.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.Ente
90 you need to ask for block 34318 in the second segment:
pg_filedump -R 34318 34320 134401986.1
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
"Et put se mouve" (Galileo Galilei)
---(end of broadcast)---
TIP 3
ssible ...
To Tom: could this be caused by a WAL recovery that wrote a page image
to the wrong table? I guess it is very unlikely because the CRC of the
WAL record would likely not match, but it's an idea.
--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
"
7;postmaster'.
>
> All was OK . Finally I restored the kernel parameters like originally
> and all works now fine !!
You forgot to mention that you set shared_buffers to 32 after initdb.
Sorry if I'm repeating myself but that seems a pretty dumb idea.
--
Alvaro Herrera
s OK. If it
complains in the same way, with a missing pg_clog file, there lies the
problem.
--
Alvaro Herrerahttp://www.planetpostgresql.org
"En las profundidades de nuestro inconsciente hay una obsesiva necesidad
de un universo lógico y coherente. Pero el univers
hat if the extract file from the mainframe has
> > an invalid character, the COPY terminates and doesn't continue loading
> > the rest of records.
>
> No, but it is on the TODO list:
Also, I think PGLoader can do this. It's on pgfoundry.org.
--
Alvaro Herrera
it's a bug. However I can't seem to find out why this
happens.
Kevin, Jeff, next time this happens please attach gdb to the autovacuum
process and get a stack trace ("bt" to gdb), if at all possible, and/or
strace it to see what it's doing.
--
Alvaro Herrera
te the referenced table at
the same time.
--
Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 17.7", W 73º 14' 26.8"
"La felicidad no es mañana. La felicidad es ahora"
---(end of broadcast)---
TIP 1: if posting/re
ar (si no funciona, es un bug, por favor reportalo).
En versiones anteriores no está permitido usar TRUNCATE en tablas que
tienen llaves foráneas, ni se permite hacer TRUNCATE en más de una
tabla simultáneamente.
--
Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4
Es
ou want to do with it? If I understand what you want to do, it
is supported as long as you use ; in place of your ||.
--
Alvaro Herrera Architect, http://www.EnterpriseDB.com
"La fuerza no está en los medios físicos
sino que reside en una volu
or message:
>
> ERROR: could not access status of transaction 6849340
> DETAIL: could not open file "/var/lib/pgsql/data/pg_clog/0006": No such
> file or directory
What version is this? Also, is the system running with fsync=off or on
disks with write cache enabled?
the stat
collector's information are lost due to the nature of the UDP socket.
You shouldn't see this problem under light load.
--
Alvaro Herrera Architect, http://www.EnterpriseDB.com
"The first of April is the day we remember what we are
the other 364 days o
u can find on the archives:
From: Tom Lane <[EMAIL PROTECTED]>
To: "Mohan, Ross" <[EMAIL PROTECTED]>
Cc: pgsql-admin@postgresql.org
Date: Wed, 13 Apr 2005 10:26:09 -0400
Subject: Re: [ADMIN] question about wal and point in time recovery
It would be nice to e
unless you wanted backends to freeze from time
to time while you take the base backup.
--
Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"La rebeldía es la virtud original del hombre" (Arthur Schopenhauer)
---(end of broadcast)
For such a small table you may want
to lower the threshold a bit. See the docs on the pg_autovacuum system
catalog, in the "internals" chapter.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Deve
t; method (-Ft option to pg_dump) and
extract the body of each element from the generated dump. Treat it as a
standard tar archive.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
---(end o
ron Dual Core" -- so is it two dual core CPUs,
or one dual core?
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
---(end of broadcast)---
TIP 3:
Marcin Giedz wrote:
> Dnia poniedzia??ek, 21 listopada 2005 16:31, Alvaro Herrera napisa??:
> > Marcin Giedz wrote:
> > > Dnia poniedzia??ek, 21 listopada 2005 11:23, Mario Splivalo napisa??:
> > > > Cool! :) Could you give specs on processors itself? The c
s for the system,
because some commands use more than one "command" internally. Exactly
what are you planning to do with it?
It would actually be trivial to put a lower limit (see the
CommandCounterIncrement function -- you'll have to recompile), but I
guess I
Yogvinder Singh wrote:
> Atleast i want to know where is this setting for Max no of commands per
> transaction
There is no setting. This is not configurable.
Please keep your replies on the list.
--
Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 17.7", W 73º 14
roper and no longer has a separate log.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
considered exploring
that?
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
uot; | pgsql logdb"
The echo-pipe is still overkill, you can do it using -c as I showed
yesterday by applying the same "trick".
--
Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 17.7", W 73º 14' 26.8"
"Es filósofo el que disfruta con lo
ere permanent, as the stats info is.
However this seems at least slightly redundant with the "maintenance
window" feature -- you could set a high barrier to vacuum during the
daily backup period instead. (Anybody up for doing this job?)
--
Alvaro Herrera http://www.
Instead of using \connect, use SET SESSION AUTHORIZATION (and connect to
the right database in the first place).
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ucky, or haven't yet detected that your data has problems.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
---(end of broadcast)---
TIP 5:
documentation
> first.
The FK routines are actually C-language functions, and pg_proc.prosrc
won't tell you much. Their definitions are in
src/backend/utils/adt/ri_triggers.c.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulti
Andy Shellam wrote:
Hi,
> As for digging through xlog.c, I'm not a C programmer so I'll stay right
> out of the way - leave that to you guys!!
You don't need to be a C programmer -- just read the code commentary.
It's easy to follow most of the
ave much useful info. You can
recreate it from template1 and nothing will be lost.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
---(end of broadcast)---
TIP 3: Have
a is still consistent.
This has been discussed before. See for example:
http://archives.postgresql.org/pgsql-bugs/2005-05/msg00079.php
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
---
stributed under
"old" BSD license, and thus require a mention in your advertising
materials, etc. ("This product contains software developed by OpenSSL
etc")
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consultin
ser password.
See the docs for the .pgpass file, in the libpq section (Interfaces).
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
---(end of broadcast)-
le?
I'll have a look at the code, but I thought I might throw that out, just
in case it rings a bell.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
---(end of broadcast)---
TIP 6: explain analyze is your friend
to do it. It was
rejected however; it was argued that there was another mechanism to
disable it. I don't remember what it was though. The only possibility
that comes to mind is "ALTER DATABASE SET autovacuum TO off" but I don't
see why would it work.
--
Alvaro Herrera
ing find $PGDATADIR/pg_tblspc -type l -printf "%???"
> )
> or do i parse output of ls !
Try the readlink utility (part of GNU coreutils, not sure about other
Unixen).
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Comma
think we will see much people losing data to Xid wraparound
anymore, now that the server refuses to work when the wraparound is
imminent.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
adey wrote:
> > 2) Can vacuum full not be redesigned to run online without locking tables
> > and users,
This is already done. See non-FULL VACUUM.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command
nd new in 8.1. You need to REVOKE the privileges
before being able to drop the role.
In 8.2 (current development) there is a commands to drop the objects
owned by the user, which additionally revokes all the privileges; and a
command to "give" the objects to someone else. The
ystem not unlike Unix's crontab might do it.
You would specify intervals at which you wish autovacuum to operate on
certain groups of tables; or intervals at which you don't want autovac
to run at all, etc.
--
Alvaro Herrerahttp://www.CommandPrompt.co
;work hours"; the rest of the tables
would continue to be vacuumed at all times.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
---(end of broadcast)---
TIP 6: explain analyze is your friend
END
END
If B or C fail, the changes made by A will persist.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
---(end of broadcast)---
TIP 4: Have you searched our
of the table, if
the field is really of SERIAL or BIGSERIAL type. However I don't see
any other way which would make the sequence go out of sync.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Dev
as a whole.
This command should produce a consistent dump of all the objects in the
database. (Not a consistent view of each object in isolation, which is
AFAIU what you are saying.)
Next question is, how are you restoring this dump?
--
Alvaro Herrerahttp://ww
Sidar López Cruz wrote:
> When transparent cross database queries will be able ???
They're not planned. Don't hold your breath. In the meantime, you can
use schemas or dblink.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replicatio
still 465752897 transactions away from that apparently.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
---(end of broadcast)---
TIP 6: explain analyze is your friend
1 - 100 of 512 matches
Mail list logo
