Ok. A little relief . It looks like only one table has no data. I guess I
need to know what cause that table has no dataGoing back to the drawing
board.
Mary
-Original Message-
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Wang,
Thanks Scott.
We used a command like this '/usr/bin/pg_dumpall -cC' postgres to do the
pg_dumpall.
I started my postmaster with this command "/usr/bin/postmaster -D
/var/lib/pgsql/data -i"
I got my tables back in the database, but I don't see any data.
What could have went wrong when I did the
On Tue, Feb 2, 2010 at 3:51 AM, fida aljounaidi
wrote:
> Hi
>
> I have an sql query which takes 20 seconds to be executed.
>
> this sql query contain more than 870 id under the select where in ()
> condition.
>
> So , it is not a large row result but a big list of conditions to be
> crossed.
>
> I
USE LEFT/JOIN instead of WHERE IN possibly would improve the performance..
On Tue, Feb 2, 2010 at 5:51 PM, fida aljounaidi
wrote:
> Hi
>
> I have an sql query which takes 20 seconds to be executed.
>
> this sql query contain more than 870 id under the select where in ()
> condition.
>
> So , it
On Tue, Feb 2, 2010 at 3:29 PM, Wang, Mary Y wrote:
> Thanks Tom.
>
> After talking to my co-worker, we decided to go to the last backup (we used
> the pg_dumpall -c command).
> However, when I did enter "psql -f /usr/pgsql/backups/31.bak template1" to
> restore the database, I got "
> psql: con
Hello,
nobody did answer so far it seems ...
> In 8.2 they had no problem. In 8.3, however they now get the following
> error
>
> On several tables:
>pg_restore: [archiver (db)] COPY failed: ERROR: character 0xe28899
> of encoding "UTF8" has no equivalent in "WIN1252"
> CONTEXT: COPY em
Thanks Tom.
After talking to my co-worker, we decided to go to the last backup (we used the
pg_dumpall -c command).
However, when I did enter "psql -f /usr/pgsql/backups/31.bak template1" to
restore the database, I got "
psql: connectDBStart() -- connect() failed: No such file or directory
Mark Corner writes:
> Yep, O will go down that road if I am not duplicating any work. In my
> experience building RPMS from SRPMS rarely just "works" :)
Really? It's supposed to. At least at Red Hat, the RPMs *are* built
from the SRPMs, nothing behind the curtain. In recent releases they're
Yep, O will go down that road if I am not duplicating any work. In my
experience building RPMS from SRPMS rarely just "works" :)
-Mark
On Feb 2, 2010, at 3:36 PM, Bruce Momjian wrote:
> Mark Corner wrote:
>>
>> So are the RPMs for postgres with non-integer datetimes available? :) For
>> ce
Mark Corner wrote:
>
> So are the RPMs for postgres with non-integer datetimes available? :) For
> centos? :)
No, but you were told how to modify the RPM configuration file to build
it that way, I think.
---
>
> On Feb
So are the RPMs for postgres with non-integer datetimes available? :) For
centos? :)
On Feb 2, 2010, at 2:00 PM, Bruce Momjian wrote:
> Devrim GÜNDÜZ wrote:
> -- Start of PGP signed section.
>> On Mon, 2010-02-01 at 11:12 -0500, Bruce Momjian wrote:
>>>
>>>
>>> No idea if anyone is building
"Wang, Mary Y" writes:
> Thanks for the help
> I was able to find pg_resetxlog in the path. Are there any precautions that
> I need to be aware of? Or I just don't have any choice?
I'd suggest taking a tarball copy of the $PGDATA tree, so you can at
least get back to where you were if it does
Tom,
Thanks for the help
I was able to find pg_resetxlog in the path. Are there any precautions that I
need to be aware of? Or I just don't have any choice?
I'd like to do pg_dump or pg_dumpall.
Should I do a pg_resetxlog $PGDATA?
Here is my pgcontrol info:
-
"Wang, Mary Y" writes:
> I'm having a bad day. My Postgresql has this error "FATAL 2: XLogFlush:
> request is not satisfied". I tried to follow the instructions from a thread
> about looking for a core dump, but when I tried to start the postmaster, I
> got "/usr/bin/postmaster: Startup proc
Devrim G?ND?Z wrote:
-- Start of PGP signed section.
> On Mon, 2010-02-01 at 11:12 -0500, Bruce Momjian wrote:
> >
> >
> > No idea if anyone is building RPMs for it
>
> Of course I'm building ;)
>
> We have pg_migrator 8.4.14 for RHEL/CentOS 4,5 and Fedora 12-i386.
Oh, wow, that's nice.
--
Hi,
I'm having a bad day. My Postgresql has this error "FATAL 2: XLogFlush:
request is not satisfied". I tried to follow the instructions from a thread
about looking for a core dump, but when I tried to start the postmaster, I got
"/usr/bin/postmaster: Startup proc 30595 exited with status 51
Achilleas Mantzios writes:
> What is the shortest way to change the default locale on a production
> installation running PostgreSQL-8.3.9?
> Is there anything less painful than dump, initdb,restore?
No :-(
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-
It seems that libc's behaviour regarding LC_COLLATE in Linux/FreeBSD are two
different stories, hence the seen results.
(Switching LC_COLLATE between en_US.UTF-8 and POSIX, in FreeBSD it does not
have any impact on orderring while in Linux does)
I think i have resolved the issue, so the solution
Hi, i have the following problem, text ordering seems to behave incosistently
across various lc_collate values, OS'es, PostgreSQL versions.
Some behaviour might be expected, some not, thats why i am asking to see where
i stand with this.
Test Data
postg...@dynacom=# SELECT * from test_sort_order;
On Mon, 2010-02-01 at 11:12 -0500, Bruce Momjian wrote:
>
>
> No idea if anyone is building RPMs for it
Of course I'm building ;)
We have pg_migrator 8.4.14 for RHEL/CentOS 4,5 and Fedora 12-i386.
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~
And maybe make sure that the id column is indexed, and see what
EXPLAIN says. http://wiki.postgresql.org/wiki/Using_EXPLAIN
--
Ian.
On Tue, Feb 2, 2010 at 10:56 AM, Bret S. Lambert wrote:
> On Tue, Feb 02, 2010 at 11:51:57AM +0100, fida aljounaidi wrote:
>> Hi
>>
>> I have an sql query which ta
On Tue, Feb 02, 2010 at 11:51:57AM +0100, fida aljounaidi wrote:
> Hi
>
> I have an sql query which takes 20 seconds to be executed.
>
> this sql query contain more than 870 id under the select where in ()
> condition.
Add a column to the table which denotes the characteristic that those
870 ids
Hi
I have an sql query which takes 20 seconds to be executed.
this sql query contain more than 870 id under the select where in ()
condition.
So , it is not a large row result but a big list of conditions to be
crossed.
I'm using postgresql 8.4.
Thanks for help
Guys,
Something I forgotten to point out.
When you do a base backup, you have also the configuration file from the
Primary, which means you will have it configured to archive as well on the WARM
server, once you restored it.
So, my guess is I must turn off the archiving process on the WARM? This
Dear all,
I apologise for this post in advance, I am sure some of you have already
answered many question and maybe find it boring by now.
I have been playing with PITR for some time now and read quite a bit about it,
it is nice feature. I am really enjoying playing with it.
I have managed to
From $ man postmaster
-i Allows remote clients to connect via TCP/IP (Internet domain)
connections. Without this option, only local connections are
accepted. This option is equivalent to setting listen_addresses
to * in postgresql.conf o
If I understood correctly what you want is to allow remote users or clients to
connect to your postgresql server
I believe this is controlled by "pg_hba.conf"
Add a line similar to:
hostall all 192.168.10.0/24 trust
Renato
Renato Oliveira
Systems Administrator
e-mai
27 matches
Mail list logo
