Hi All,
I have some other issue related to taking backup of the database having
bigger size. I have been getting the
following errors
anil@ubuntu107:~/Desktop$ pg_dump -Uadmin -h192.168.2.5 dbname >
filename.sql
pg_dump: Dumping the contents of table "tbl_voucher" failed:
PQgetCopyData() faile
On 26 Srpen 2011, 11:48, Niyas wrote:
> Hi All,
>
> I have some other issue related to taking backup of the database having
> bigger size. I have been getting the
> following errors
>
> anil@ubuntu107:~/Desktop$ pg_dump -Uadmin -h192.168.2.5 dbname >
> filename.sql
>
> pg_dump: Dumping the content
El día 26 de agosto de 2011 00:04, Merlin Moncure escribió:
> 2011/8/25 Martín Marqués :
>> CREATE OR REPLACE FUNCTION prueba_cursor(codigo integer, curCursor refcursor)
>> RETURNS SETOF refcursor AS
>> $BODY$
>> DECLARE
>> cur alias for $2;
>> BEGIN
>> PERFORM mpf.ConstruyeCursorDes
Actually database is not crashed. I can run my application perfectly.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/backup-strategies-for-large-databases-tp4697145p4737697.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-ge
On 26 Srpen 2011, 12:46, Niyas wrote:
> Actually database is not crashed. I can run my application perfectly.
That does not mean one of the backends did not crash. Check the log.
Tomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
h
Hello
2011/8/26 Niyas :
> Hi All,
>
> I have some other issue related to taking backup of the database having
> bigger size. I have been getting the
> following errors
>
> anil@ubuntu107:~/Desktop$ pg_dump -Uadmin -h192.168.2.5 dbname >
> filename.sql
>
> pg_dump: Dumping the contents of table "t
I also guessed the same at initial stage of debugging. So i tried to export
the tbl_voucher data
to a file and it works fine. Then i googled and found some link, its
explaines the reason is
higher size of the database. But didnt get any proper solution in the
internet.
--
View this message in con
Sushant,
Can this fit?
>
> select plainto_tsquery('english', 'the quick brown fox jumped over the
> lazy fox');
> plainto_tsquery
> -
> 'quick' & 'brown' & 'fox' & 'jump' & 'lazi' & 'fox'
>
no, this cannot fit. This just adds
Hello,
today I try to restore on of my tables with copy from file that I made
before.
The file is 2.4 GB, only integers ... took me 3 hours and 30 min and I
hit
CTRL+C on i7 processor with 8 GB memory, sata 2 hard drive. I modify
some
psql conf file values and increase memory, work, wal, temp,
2011/8/26 Martín Marqués :
> El día 26 de agosto de 2011 00:04, Merlin Moncure
> escribió:
>> 2011/8/25 Martín Marqués :
>>> CREATE OR REPLACE FUNCTION prueba_cursor(codigo integer, curCursor
>>> refcursor)
>>> RETURNS SETOF refcursor AS
>>> $BODY$
>>> DECLARE
>>> cur alias for $2;
>>> B
> Date: 08/26/2011 05:40 PM
> Subject: [GENERAL] COPY FROM how long should take ?
> Sent by: pgsql-general-ow...@postgresql.org
>
> Hello,
> today I try to restore on of my tables with copy from file that I made
> before.
> The file is 2.4 GB, only integers ... took me 3 hours and 30 min and I
>
> a) the lexems of a tsvector
ts_debug (it`s a plain sql function, may give You some inspiration for
Your own queries)
> b) the (unnamed) fields of a set-of-record-returning function
select * from ts_parse('default','the quick brown fox jumped over the lazy fox')
or
select (ts_parse('default','the
Dear List
Since 9.0 comes out, I had been successfully using wal file shipping
readonly hotstandby feature in pg. I am currently trying to
reestablish a readonly slave after master node failure.
The newly established master server is working properly. I have
verified that WAL file shipping is
Could anyone tell me where to find postgresql 9.0.4 SRPM's?
I need to build some RPM's for CentOS 6 - 32 bit.
Thanks in advance...
On Fri, 26 Aug 2011 17:49:35 +0530, Jayadevan M wrote:
>> Date:
08/26/2011 05:40 PM
>> Subject: [GENERAL] COPY FROM how long should
take ?
>> Sent by: pgsql-general-ow...@postgresql.org
>>
> > Hello,
>
> today I try to restore on of my tables with copy from file that I made
> > before.
>
Massa, Harald Armin wrote:
> select ts_parse('default','the quick brown fox jumped over the lazy fox')
>
> (1,the)
> (12," ")
> (1,quick)
> [...]
> (1,fox)
>
> is a set-returning-function, giving me 17 records of type pseudo-record.
> Stopwords still in there, so what. But: No chance of
On Fri, 2011-08-26 at 13:33 +0100, Brett Maton wrote:
> Could anyone tell me where to find postgresql 9.0.4 SRPM's?
>
> I need to build some RPM's for CentOS 6 - 32 bit.
http://yum.postgresql.org/srpms/9.0
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterpris
column types are the same so I don't know why this 'union all' is failing.
Any ideas?
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
here is the error:
ERROR: syntax error at or near "UNION"
LINE 17: UNION ALL
^
** Error **
ERROR: syntax error a
On Fri, 2011-08-26 at 09:28 -0400, Joy Smith wrote:
> column types are the same so I don't know why this 'union all' is failing.
> Any ideas?
>
You cannot have an ORDER BY before the UNION ALL. The manual says:
[ WITH [ RECURSIVE ] with_query [, ...] ]
SELECT [ ALL | DISTINCT [ ON ( expression
Joy Smith writes:
> column types are the same so I don't know why this 'union all' is failing.
It's a syntax error --- got nothing to do with column types.
I think what you need to do is parenthesize the first subquery. ORDER
BY isn't allowed to be attached to a UNION subquery otherwise. You'r
Thanks for the suggestions,
combining your and Guillaume Lelarge suggestions
I was able to get it two work.
I had to do two things.
1. take away the with's and just drop them into my from statement
2. remove the order by's
so the working sql is as follows:
select
'Phone 611 IVR',
'New States
Hello Guillaume, thanks your and Tom's solutions worked.
I did find the page you cited though I admit when I was reading through all
the bracets i was not sure if it was telling me a precedence, order or what.
I am sure as i get better the following will read quite clearly.
[ WITH [ RECURSIVE ]
Thanks Devrim,
There was no SRPM for 9.0.4 under the i386 folder, but there was one in
the x86_64.
rpmbuild reported no errors once I got all of the dependencies installed.
All seems to be working sweetly now.
Brett
2011/8/26 Devrim GÜNDÜZ
> On Fri, 2011-08-26 at 13:33 +0100, Brett Mato
On Thu, Aug 25, 2011 at 7:41 PM, Tom Lane wrote:
> Lonni J Friedman writes:
>> [ this doesn't work: ]
>> $ cat 2011-08-25-1314280801-nightly.out | pg_restore -j2 -U lfriedman -v -d
>> nightly
>
> It's basically impossible for that to work. -j implies spawning
> multiple processes that will be w
You can add a trigger and send message every 10 rows
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
The better solution is you write own hashing function.
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Is there a way to get output from a SQL command or function and have it be set
to a variable value in psql? My main goal is to execute a certain script
depending on the version of the database server (either 8.4 or 9.0). I can
dynamically execute a script using the following, but I can't get i
On Fri, Aug 26, 2011 at 3:01 PM, Bobby Dewitt wrote:
> Is there a way to get output from a SQL command or function and have it be
> set to a variable value in psql? My main goal is to execute a certain
> script depending on the version of the database server (either 8.4 or 9.0).
> I can dynamica
On 08/26/2011 02:16 PM, Merlin Moncure wrote:
> On Fri, Aug 26, 2011 at 3:01 PM, Bobby Dewitt wrote:
>> Is there a way to get output from a SQL command or function and have it be
>> set to a variable value in psql? My main goal is to execute a certain
>> script depending on the version of the d
I'm using a home-grown Ruby script to execute a given SQL script against
all of the databases in our environment. I could modify the Ruby script
to execute a different SQL script depending on the database version, but
that would require a lot of changes to the Ruby code and would probably
only be
I am running postgresql 8.3.3 on solaris
My server has a number of databases. I have a problem with only one of them.
That particular database got corrupted and I do not yet know the cause. No
hardware problems as far as I can see.
I am not able to search on a view that I was able to do before.
Hi All,
What's the correct method of writing array columns using the bulk copier.
It seems to support the
curly braces notation but how do you escape special characters like ","?
I tried using "\x2c" and that prevents the syntax error but I end up with
what looks like the string
\x2c in the data
Postgres 9.0 on Solaris 10. Is there any meaningful way to check the contents
of a WAL file? I had a server run out of space and I wanted to check the WAL
files to see what was going on that filled up the disk space. No errors in the
log file so whatever was running was running "error free" unti
I'm wondering how it's possible to upgrade my fedora system's pg to
the latest minor release. I'm using the PGDG RPMs. A "yum update"
leaves me on version 9.0.2. I'd expect it to put me on 9.0.4. What am
I doing wrong? I installed from pgdg-fedora-9.0-2.noarch .
Cheers,
John
--
Sent via pgsql-ge
> I created a new view called "clients2" with the same member tables as clients
> and it works I can query it.
>
> But due to the many hardcoded places that use "clients" view, I have to have
> "clients" view. So I tried to drop clients view but cannot
>
> #DROP view clients;
> ERROR: missin
Hi. Maybe last bugfix helps you.
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
36 matches
Mail list logo
