oken, it will happen
> again...
> If you have more than one database in your cluster, you can find what's
> the database that's been corrupted and restore just that one, instead of
> the whole cluster.
> Cheers
> Moreno
>
>
>
> On Wed, Apr 19, 2017 at 10:18 AM
ws (or your hardware)
> destroy your data on crash. is there some RAID cache that is not backed up
> by a battery?
>
>
> On Wed, Apr 19, 2017 at 10:18 AM, Alexandre wrote:
>
>> Hello,
>>
>> The computer had a unexpected shutdown, it is a Windows machine.
>
Hello,
The computer had a unexpected shutdown, it is a Windows machine.
Now some data appears to be corrupted, I am receiving exceptions like this:
ERROR: could not read block 0 in file "base/16393/16485": read only
0 of 8192 bytes
There is some way to correct this?
#x27;t know if is
the correct way to use plpythonu, and if I will have future problems.
Another question is that I have read in some discussion list (old
message year 2003) the possibility of plpython be removed from
postgresql, this information is valid yet?
sorry bad En
t the result is exactly like the first one but
perfectly reversed in it's order?
Best regards.
--
Alexandre Leclerc
Projets spéciaux
Ipso Systèmes Stratégiques inc.
176 boul. Harwood (suite 10), Vaudreuil-Dorion, QC, J7V 1Y2
Tel: 450-424-6847 ext. 108 / 1-800-879-4776
Fax: 450-424-843
Daniel Verite a écrit :
> Alexandre Leclerc wrote:
>
>> SELECT * from t1 ORDER BY date, time DESC;
>> date (date type) time (varchar) data
>> 2007-01-30 9h30 d2
>> 2007-01-3017h20 d5
>> 2007-01-3013h45
t; needs to be 09h30 and so forth.
Exactly. This is sorted that way. This is what I'll do, inserting a 0.
Best regards.
--
Alexandre Leclerc
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
c
t the result is exactly like the first one but
perfectly reversed in it's order?
Best regards.
--
Alexandre Leclerc
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
Tom Lane wrote:
Alexandre Arruda <[EMAIL PROTECTED]> writes:
But pg_stat_activity joined with pg_locks only give me informations
about the lock itself.
Realy, I want a (possible) simple information: Who is locking me ?
You need a self-join to pg_locks to find the matching lock that i
Alvaro Herrera escreveu:
Alexandre Arruda wrote:
Hi,
My Database have a lot of locks not granted every moments in a day.
Can I create a view that returns someting like this ?
UserGranted Table Who_is_locking_me PID
--- - - ---
joe f foo
frank 1313
ann f foo frank 1414
frank t foo
(...)
(Or the locked transactions, if the table cold't be retrived)
pg_locks view does not give me WHO is locking...
Best regards,
Alexandre
--
y, your indexes. If you want to restore one table from a file,
you have previously to know what the indexes and PK the table have and
restore each manually.
Thanks,
Alexandre
Pavel Golub wrote:
> Hello, pgsql-general.
>
> Is it possible to create not only executable version of pg_dump an
Richard Huxton wrote:
> alexandre - aldeia digital wrote:
>> Hi,
>>
>> If I do:
>>
>> pg_dump -Fc -t TABLE database > table-custom.sql
>>
>> The pg_dump returns the DDL of the table, the data and the DDL for
>> indexes and PK. If I use -s,
tore -Fc -t TABLE backup-custom.file > table-plain.sql
Only the DDL of table and data is returned, but not indexes, etc.
Question:
How can I restore a table with all other dependences from a custom file
database ?
PG 8.1.3
Thanks,
Alexandre
---(en
table.sql
Only the DDL of table and data is returned, but not indexes, etc.
Question:
How can I restore a table with all other dependences from a custom file
database ?
PG: 8.1.2 and 8.0.6
Thanks,
Alexandre
---(end of broadcast)---
TIP 9: In
table.sql
Only the DDL of table and data is returned, but not indexes, etc.
Question:
How can I restore a table with all other dependences from a custom file
database ?
PG: 8.1.2 and 8.0.6
Thanks,
Alexandre
---(end of broadcast)---
TIP 2: Don&#
Michael Fuhr wrote:
On Mon, Jan 02, 2006 at 08:45:28AM -0200, alexandre - aldeia digital wrote:
In my Linux bash backup scripts, I wish to send an e-mail when an error
occurs in pg_dump proccess. And if possible, I want to send the error
output via e-mail.
Anybody knows how to capture the
?
Thanks
Alexandre
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Chris Guo wrote:
Dear all,
We are using Fedora Core 3 in our company, and we installed postgresql
8.0.3 as the database system. I wonder if anybody has the start up
script for this version so we can start postgresql service
automatically after we reboot the server.
Any help will be high
---
Tom Lane wrote:
Alexandre Barros <[EMAIL PROTECTED]> writes:
max_connections, shared_buffers, shmmax were tweaked, but the server
does not seems to respect the 500 max_connections...
Er ... did you restart the postmaster after increasing those parameters?
regar
> > hardware, I already changed memory, what can I try now ? the processor
> > ? motherboard ??
>
> > On 5/3/05, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> > > On Tue, 2005-05-03 at 15:04, Alexandre Biancalana wrote:
> > > > Thank you for the detailed expl
on 30/05/05 20:47, Andrus <[EMAIL PROTECTED]> wrote:
> I installed Postgres 8 to Windows XP and added a line
>
> hostall all 168.179.0.1/32 trust
>
> to pg_hba.conf file
>
>
> When connection from LAN to the Postgres with user name postgres I got error
>
> no pg_h
I have a big problem to jump from 7.2 to 8.0.3
In my application I was doing a major use of int and float
And the difference between '0' and void NULL '' data content.
Now it seems to me that void is not allowed for an integer ?
What should I do ?
---(end of broadcast)--
Ohhh god :(
The FreeBSD is the last STABLE version. I can try to change some
hardware, I already changed memory, what can I try now ? the processor
? motherboard ??
On 5/3/05, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Tue, 2005-05-03 at 15:04, Alexandre Biancalana wrote:
>
Thank you for the detailed explanation Scott, they are very handy !!
I reduced the shared_buffers to 32768, but the problem still occurs.
Any other idea ??
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister co
On 5/3/05, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Tue, 2005-05-03 at 11:36, Alexandre Biancalana wrote:
> > >>You need to find out what's triggering that. Turning on query logging
> > >>would be a good way of investigating.
> >
&g
>>You need to find out what's triggering that. Turning on query logging
>>would be a good way of investigating.
Which directives can I use to enable this ?
debug_print_parse ? debug_print_rewritten ? debug_print_plan ?
debug_pretty_print ?
>>Rather large, shared buffers for a machine with only
could result in this kind of problem ?
Any ideas ? Any thoughts ?
Best Regards,
Alexandre
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Chris (and others), thank you for the good explanation! =)
I will try to use database as you recommend, thank you again for the
advices!
Regards,
/Alexandre.
On Apr 20, 2005, at 17:39, Chris Browne wrote:
I think you're missing two points:
1. With careful design, the ISAM "wrapper&qu
I understand, that there is already a lot of overhead, but Berkeley DB
also "provides strict ACID transaction semantics". Would you like to
say, that PostgreSQL will be faster on simple operations than Berkeley
DB?
Regards,
/Alexandre.
---(end of broadcast)-
, in some, of course,
SQL is more suitable.
As Tom said absolutely correct, in such situations Berkeley DB is
something that more suitable, but it will add another one database, so
ISAM-like (native, which does not translate it's calls to the SQL)
access to the PostgreSQL will be just f
On Apr 19, 2005, at 23:24, Dan Sugalski wrote:
At 9:40 PM +0400 4/19/05, Alexandre wrote:
Lane, thank you, but it is not: PostISAM "generates SQL statements on
the fly from traditional ISAM (read, write, start) statements", so it
just add overhead, and is not what I'm looking for
,
/Alexandre.
On Apr 19, 2005, at 22:37, Tom Lane wrote:
Alexandre <[EMAIL PROTECTED]> writes:
Lane, thank you, but it is not: PostISAM "generates SQL statements on
the fly from traditional ISAM (read, write, start) statements", so it
just add overhead, and is not what I'm looking fo
Lane, thank you, but it is not: PostISAM "generates SQL statements on
the fly from traditional ISAM (read, write, start) statements", so it
just add overhead, and is not what I'm looking for.
Anyway, thank you for the information.
Regards,
/Alexandre.
On Apr 19, 2005, at 18:16,
features, which realized great in PostgreSQL (for
example, recovery, transactions) and I will get harder administrative
support, backup and so on.
Thank you in advance,
Regards,
/Alexandre.
---(end of broadcast)---
TIP 8: explain analyze is your
Blobs is not Implemented on PostgreSQL,
but I need to this field type on
PosgreSQL databases, how I can to use this?
I'm using delphi...
ps: I readed PosgreSQL Manual and other lists and
sites, but not get a answer for my specific problem
ion" thats needs to run "isolated", and a
function to kill anybody is very usefull.
Thanks for your help.
Alexandre
Functions written in C, PL/Perl, PL/Tcl, etc., can use whatever
facilities those languages provide, such as sending signals to
processes. Whether that's
ng process before execute this, to avoid the lock wait.
Thanks for any help
Alexandre de Arruda Paes
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Hi,
You need to create you database with an enconding like LATIN1:
createdb -E latin1 mydb
Alexandre
Juan Jose Siles Salinas wrote:
Cuando subo la base de datos con pg_restore -d mydb < mydb.tar
restablece toda la informacion pero los acentos y ñ muestran caracteres
en otra codificacion c
Hi,
I have a 4 x SCSI in RAID 10 (PG 7.4.6) with a regular performance.
My database have 55 Gb of data.
In PG 8, moving the indexes to a separeted disk (or array) can
(generally) improve the performance if the system make a heavy use of
indexes ?
Thanks
Alexandre
---(end
Is there a version of pg_dump that save blob ?
___
Vendez tout... aux enchères - http://www.caraplazza.com
41 matches
Mail list logo
