Re: [GENERAL] Idle processes chewing up CPU?
Hi Tom,
I think I've confirmed the fix. Using a dirty disconnect generator, I was
able to reliably recreate the problem within about 30-60 seconds. The
symptoms were the same as before, however it occurred around SSL_write
instead of SSL_read - I assume this was due to the artificial nature of the
dirty disconnect (easier for the client to artificially break the connection
while waiting/receiving, than sending).
The solution you proposed solved it for SSL_write (ran for 30 minutes, no
runaway processes), and I think it's safe to assume SSL_read too. So I
suggest two additions:
rloop:
+ errno = 0;
n = SSL_read(port->ssl, ptr, len);
err = SSL_get_error(port->ssl, n);
switch (err)
{
case SSL_ERROR_NONE:
port->count += n;
break;
And:
wloop:
+ errno = 0;
n = SSL_write(port->ssl, ptr, len);
err = SSL_get_error(port->ssl, n);
switch (err)
{
case SSL_ERROR_NONE:
port->count += n;
break;
I'm not comfortable running my own compiled version in production (it was
rather difficult to get it working), so I'm interested to know when the next
release is planned. We can test beta copies on a non-critical load balancing
server if necessary.
Cheers,
-Brendan
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Sunday, 27 September 2009 2:42 PM
To: Brendan Hill
Cc: 'Craig Ringer'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Idle processes chewing up CPU?
"Brendan Hill" writes:
> Makes sense to me. Seems to be happening rarely now.
> I'm not all that familiar with the open source process, is this likely to
be
> included in the next release version?
Can you confirm that that change actually fixes the problem you're
seeing? I'm happy to apply it if it does, but I'd like to know that
the problem is dealt with.
regards, tom lane
> -Original Message-
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Sent: Monday, 21 September 2009 5:25 AM
> To: Brendan Hill
> Cc: 'Craig Ringer'; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Idle processes chewing up CPU?
> "Brendan Hill" writes:
>> My best interpretation is that an SSL client dirty disconnected while
>> running a request. This caused an infinite loop in pq_recvbuf(), calling
>> secure_read(), triggering my_sock_read() over and over. Calling
>> SSL_get_error() in secure_read() returns 10045 (either connection reset,
> or
>> WSAEOPNOTSUPP, I'm not sure) - after this, pq_recvbuf() appears to think
>> errno=EINTR has occurred, so it immediately tries again.
> I wonder if this would be a good idea:
> #ifdef USE_SSL
> if (port->ssl)
> {
> int err;
> rloop:
> + errno = 0;
> n = SSL_read(port->ssl, ptr, len);
> err = SSL_get_error(port->ssl, n);
> switch (err)
> {
> case SSL_ERROR_NONE:
> port->count += n;
> break;
> It looks to me like the basic issue is that pq_recvbuf is expecting
> a relevant value of errno when secure_read returns -1, and there's
> some path in the Windows case where errno doesn't get set, and if
> it just happens to have been EINTR then we've got a loop.
> regards, tom lane
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] please help
Dear sir, I work as a new DBA in postgresql, please recommend some good books, website for tutorial. thanks Shu _ Hotmail: Powerful Free email with security by Microsoft. http://clk.atdmt.com/GBL/go/171222986/direct/01/
[GENERAL] Error during make when installing geos for postgis install...still trying
Still having problems installing the geos file when trying to install postgis...have a printout of errors we are still getting computer/compiler/postgis info rhel 5, gcc-4.1.2-46el14.4.1 postgis1.4.0 below is our process and the errors we are getting, can anyone tell us where the issue is? [r...@zoa-project postgis-1.4.1]# ./configure checking build system type... i686-pc-linux-gnu checking host system type... i686-pc-linux-gnu checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ISO C89... none needed checking for a sed that does not truncate output... /bin/sed checking for grep that handles long lines and -e... /bin/grep checking for egrep... /bin/grep -E checking for fgrep... /bin/grep -F checking for ld used by gcc... /usr/bin/ld checking if the linker (/usr/bin/ld) is GNU ld... yes checking for BSD- or MS-compatible name lister (nm)... /usr/bin/nm -B checking the name lister (/usr/bin/nm -B) interface... BSD nm checking whether ln -s works... yes checking the maximum length of command line arguments... 98304 checking whether the shell understands some XSI constructs... yes checking whether the shell understands "+="... yes checking for /usr/bin/ld option to reload object files... -r checking how to recognize dependent libraries... pass_all checking for ar... ar checking for strip... strip checking for ranlib... ranlib checking command to parse /usr/bin/nm -B output from gcc object... ok checking how to run the C preprocessor... gcc -E checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking for dlfcn.h... yes checking for objdir... .libs checking if gcc supports -fno-rtti -fno-exceptions... no checking for gcc option to produce PIC... -fPIC -DPIC checking if gcc PIC flag -fPIC -DPIC works... yes checking if gcc static flag -static works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.o... (cached) yes checking whether the gcc linker (/usr/bin/ld) supports shared libraries... yes checking whether -lc should be explicitly linked in... no checking dynamic linker characteristics... GNU/Linux ld.so checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... yes checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes checking for gcc... (cached) gcc checking whether we are using the GNU C compiler... (cached) yes checking whether gcc accepts -g... (cached) yes checking for gcc option to accept ISO C89... (cached) none needed checking how to run the C preprocessor... gcc -E checking for g++... no checking for c++... no checking for gpp... no checking for aCC... no checking for CC... no checking for cxx... no checking for cc++... no checking for cl.exe... no checking for FCC... no checking for KCC... no checking for RCC... no checking for xlC_r... no checking for xlC... no checking whether we are using the GNU C++ compiler... no checking whether g++ accepts -g... no checking whether we are using the GNU C++ compiler... (cached) no checking whether g++ accepts -g... (cached) no checking if gcc supports -Wall... yes checking if gcc supports -Wmissing-prototypes... yes checking for perl... /usr/bin/perl checking for flex... flex checking lex output file root... lex.yy checking lex library... -lfl checking whether yytext is a pointer... yes checking for bison... bison -y checking ieeefp.h usability... no checking ieeefp.h presence... no checking for ieeefp.h... no checking for convert... no configure: WARNING: ImageMagick does not seem to be installed. Documentation cannot be built checking for xsltproc... /usr/bin/xsltproc checking for dblatex... no configure: WARNING: dblatex is not installed so PDF documentation cannot be built configure: WARNING: could not locate Docbook stylesheets required to build the documentation checking CUnit/CUnit.h usability... no checking CUnit/CUnit.h presence... no checking for CUnit/CUnit.h... no configure: WARNING: could not locate CUnit required for liblwgeom unit tests checking iconv.h usability... yes checking iconv.h presence... yes checking for iconv.h... yes checking for libiconv_open in -liconv... no checking for iconv_open in -lc... yes checking for pg_config... /usr/bin/pg_config checking libpq-fe.h usability... yes checking libpq-fe.h presence... yes checking for libpq-fe.h... yes checking for
Re: [GENERAL] Save MySQL? HA
On Thu, 2009-12-31 at 21:08 -0800, John R Pierce wrote: > Dann Corbit wrote: > > I suspect that Oracle could be interested in collection of revenue from > > MySQL users who are using it commercially without a license in violation > > of the current license agreement for MySQL. (Commercial use of MySQL > > without paying a license fee requires that projects using the database > > are also GPL, IIRC) > > I'm pretty sure this only applies to commercial software thats > distributed -with- MySQL Guys, this is wholly off-topic. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Save MySQL? HA
On Thu, Dec 31, 2009 at 7:20 PM, Andrew Lardinois wrote: > Can't help myself, but I've used mysql in the past, and got on a list of > some sort once upon a time about that. Just received an email petition from > Monty to help save mysql. Certainly you know the story: Oracle buys Sun, > which currently owns mysql, and the little dolphin get's flushed down the > drain. Perhaps they should watch The Cove, a documentary about dolphins > biting the dust. Be nice! I really think that Oracle owning MySQL could be the best thing to happen to it. If they put even a tiny percentage of their programming man power behind it they could have one of the fastest key-value databases in myisam storage, which is very useful for certain types of apps. They could also fix a lot of long standing mental retardation that's been allowed to live on forever (innodb tables ignoring column level FK constraints, no FTS on innodb etc). If they got it to the point that all the parts that burn with the stupid were fixed, it would be useful as a sales tool, step up kinda thing. Monty made his be, let him lie in it. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Save MySQL? HA
Dann Corbit wrote: I suspect that Oracle could be interested in collection of revenue from MySQL users who are using it commercially without a license in violation of the current license agreement for MySQL. (Commercial use of MySQL without paying a license fee requires that projects using the database are also GPL, IIRC) I'm pretty sure this only applies to commercial software thats distributed -with- MySQL -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Save MySQL? HA
> -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Peter Geoghegan > Sent: Thursday, December 31, 2009 8:23 PM > To: Andrew Lardinois > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Save MySQL? HA > > Andrew, > > I don't think it's becoming of the Postgres community to gloat about > this. Your contention that MySQL will "get flushed down the drain" > sounds almost as misguided as Monty's contention that Oracle will > divest in, and ultimately somehow "kill" MySQL as a means of cornering > the RDBMS market. > > The reason that MySQL can boast having so many installs is because it > is used in shared hosting shops around the world. I really strongly > doubt that Oracle are entertaining the idea of moving those sorts of > MySQL users (i.e. the majority) over to Oracle database - they want to > find a way to extract money from them, if that's possible. They > certainly won't have a monopoly on supporting MySQL that they can use > as leverage. Even if Oracle *could* somehow kill MySQL, I think it's > extremely unlikely that they'd be the beneficiary, and they know it. I > say this as someone who is largely indifferent to what happens to > MySQL, beyond the ramifications for PostgreSQL. I suspect that Oracle could be interested in collection of revenue from MySQL users who are using it commercially without a license in violation of the current license agreement for MySQL. (Commercial use of MySQL without paying a license fee requires that projects using the database are also GPL, IIRC). Just a wild guess, of course. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Save MySQL? HA
Andrew, I don't think it's becoming of the Postgres community to gloat about this. Your contention that MySQL will "get flushed down the drain" sounds almost as misguided as Monty's contention that Oracle will divest in, and ultimately somehow "kill" MySQL as a means of cornering the RDBMS market. The reason that MySQL can boast having so many installs is because it is used in shared hosting shops around the world. I really strongly doubt that Oracle are entertaining the idea of moving those sorts of MySQL users (i.e. the majority) over to Oracle database - they want to find a way to extract money from them, if that's possible. They certainly won't have a monopoly on supporting MySQL that they can use as leverage. Even if Oracle *could* somehow kill MySQL, I think it's extremely unlikely that they'd be the beneficiary, and they know it. I say this as someone who is largely indifferent to what happens to MySQL, beyond the ramifications for PostgreSQL. Regards, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Migration of db
akp geek wrote on 31.12.2009 21:45: Hi All - We have 2 databases test and prod. Now they are out of sync ( of course they will be to some extent ). But there are some functions in some schemas. we have to sync from prod to test. What I wanted to ask, is there any tool that you recommend for version control. Because we are having tough time tracking the changes Regards Have a look at Liquibase: www.liquibase.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Save MySQL? HA
Can't help myself, but I've used mysql in the past, and got on a list of some sort once upon a time about that. Just received an email petition from Monty to help save mysql. Certainly you know the story: Oracle buys Sun, which currently owns mysql, and the little dolphin get's flushed down the drain. Perhaps they should watch The Cove, a documentary about dolphins biting the dust. Are we going to capitalize on this turn of events? Andrew Lardinois
Re: [GENERAL] Query very slow when in plpgsql function
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > And when I execute the function with the same parameters it takes well > over 5 minutes to execute. > > It seems as though inside a function, the optimizer wants to tablescan > my 8M row table. Is there a way that I can see the query plans that my > functions are using? See my blog post on this: http://blog.endpoint.com/2008/12/why-is-my-function-slow.html It's also in the first page of hits when you google the subject line of this thread. :) - -- Greg Sabino Mullane g...@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key: 0x14964AC8 200912311751 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iEYEAREDAAYFAks9Kz8ACgkQvJuQZxSWSsj72QCgvrcUOTF8cXyVkIZ29ky3YOmp p+IAoOmgyTICVXBmndHADua3ypNC0ctK =dZtE -END PGP SIGNATURE- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Migration of db
On Thu, Dec 31, 2009 at 1:45 PM, akp geek wrote: > Hi All - > We have 2 databases test and prod. Now they are out of sync ( of > course they will be to some extent ). But there are some functions in some > schemas. we have to sync from prod to test. What I wanted to ask, is there > any tool that you recommend for version control. Because we are having tough > time tracking the changes I've used the poor man's version control in the past. Make a table: create table version_control(id numeric primary key, description text, applied timestamp default now()); And then in every bit of DDL you submit to the DB, you put a single line at the top to insert the proper values to identify it. Then you can just compare the various dbs' version_control tables to see what's missing etc. Assuming you don't let tom, dick, harry and all their friends run ddl on the prod / staging / qa databases and pay attention to what you're doing it should work well. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Migration of db
2009/12/31 akp geek : > Hi All - > We have 2 databases test and prod. Now they are out of sync ( of > course they will be to some extent ). But there are some functions in some > schemas. we have to sync from prod to test. What I wanted to ask, is there > any tool that you recommend for version control. Because we are having tough > time tracking the changes > Regards You could always use Post Facto: http://www.post-facto.org/ Note, however, it's still in alpha. Regards Thom -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Migration of db
Hi All - We have 2 databases test and prod. Now they are out of sync ( of course they will be to some extent ). But there are some functions in some schemas. we have to sync from prod to test. What I wanted to ask, is there any tool that you recommend for version control. Because we are having tough time tracking the changes Regards
Re: [GENERAL] Query very slow when in plpgsql function
On 1/01/2010 12:05 AM, Chris McDonald wrote: FOR matchRecord IN same query as above LOOP RETURN NEXT matchRecord.evaluationid; END LOOP; And when I execute the function with the same parameters it takes well over 5 minutes to execute. It's as if you PREPAREd the query once, and each time you run the function it gets EXECUTEd. The query plan is cached. Unfortunately, when PostgreSQL builds a prepared statement (or query in a function) it doesn't have knowledge of exact parameter values, which limit its use of statistics for query optimisation. Currently there is no way to ask PostgreSQL to re-plan such queries at each execution. You have to force it by using a query that cannot be cached. In PL/PgSQL the usual method is to use EXECUTE ... USING to provide the query as text that is parsed and executed each time the function gets invoked. It seems as though inside a function, the optimizer wants to tablescan my 8M row table. Is there a way that I can see the query plans that my functions are using? Not directly. However, if you PREPARE your query, then EXPLAIN ANALYZE EXECUTE it with the parameters you use, you'll see the same effects. (Hmm, this needs to be a FAQ) -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Query very slow when in plpgsql function
Hi everyone.
I am using postgresql 8.3.7 on Fedora Core 10. I have 1 table called
evaluation which contains about 1 million records, and another called
evaluationentry which contains about 9 million records.
evaluationentry.veto and evaluation.relevancedt both have indexes on
them. I have run ANALYZE against the tables to ensure I have stats. I
execute query:
SELECT T1.evaluationid, MIN(T2.evalresult)
FROM sharemgr.evaluation T1 INNER JOIN
sharemgr.evaluationentry T2 ON (T1.evaluationid = T2.evaluationid)
WHERE T1.relevancedt BETWEEN CAST('2009-06-15 00:00:00' AS TIMESTAMP)
AND CAST('2009-06-15 23:59:59' AS TIMESTAMP)
AND T2.veto = 'Y'
GROUP BY T1.evaluationid
HAVING MIN(T2.evalresult) = 100
and it returns about 10 results (correctly) in about 4 seconds - which
I am more than happy with given the underlying hardware and
virtualization layer.
QUERY PLAN:
===
HashAggregate (cost=197446.95..197454.58 rows=436 width=9) (actual
time=386.877..387.193 rows=10 loops=1)
Filter: (min(t2.evalresult) = 100::numeric)
-> Nested Loop (cost=0.00..197423.83 rows=3082 width=9) (actual
time=0.319..302.310 rows=4438 loops=1)
-> Index Scan using evaluation_i3 on evaluation t1
(cost=0.00..249.97 rows=436 width=4) (actual time=0.130..12.633
rows=634 loops=1)
Index Cond: ((relevancedt >= '2009-12-14
00:00:00'::timestamp without time zone) AND (relevancedt <=
'2009-12-14 23:59:59'::timestamp without time zone))
-> Index Scan using evaluationentry_i1 on evaluationentry t2
(cost=0.00..440.57 rows=933 width=9) (actual time=0.031..0.172 rows=7
loops=634)
Index Cond: (t2.evaluationid = t1.evaluationid)
Filter: (t2.veto = 'Y'::bpchar)
Total runtime: 387.669 ms"
===
I then made this query into a function so I can pass in the 2
timestamps, and return T1.evaluationid as a SETOF INT by doing
FOR matchRecord IN
same query as above
LOOP
RETURN NEXT matchRecord.evaluationid;
END LOOP;
And when I execute the function with the same parameters it takes well
over 5 minutes to execute.
It seems as though inside a function, the optimizer wants to tablescan
my 8M row table. Is there a way that I can see the query plans that my
functions are using?
Any suggestions welcome...
chris
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] set-level update fails with unique constraint violation
On Thu, Dec 31, 2009 at 10:52:20AM +0100, neuhauser+pgsql-general#postgresql@sigpipe.cz wrote: > Hello, > > this fails with "duplicate key value": > > CREATE TABLE x ( > i INT NOT NULL UNIQUE > ); > INSERT INTO x (i) VALUES (1), (2), (3); > UPDATE x SET i = i + 1; > > are there any plans to make this work? This will work in 8.5: CREATE TABLE x ( i int NOT NULL UNIQUE DEFERRABLE INITIALLY DEFERRED ); INSERT INTO x (i) VALUES (1), (2), (3); UPDATE x SET i = i + 1; Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] set-level update fails with unique constraint violation
2009/12/31 neuhauser+pgsql-general#postgresql.org : > Hello, > > this fails with "duplicate key value": > > CREATE TABLE x ( > i INT NOT NULL UNIQUE > ); > INSERT INTO x (i) VALUES (1), (2), (3); > UPDATE x SET i = i + 1; > > are there any plans to make this work? Sure. 8.5 (current alpha release included) will let you do i INT NOT NULL UNIQUE DEFERRABLE which will make that work. (you might want to consider using an actual email address if you want to get responses to your questions in the future) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] set-level update fails with unique constraint violation
Hello, this fails with "duplicate key value": CREATE TABLE x ( i INT NOT NULL UNIQUE ); INSERT INTO x (i) VALUES (1), (2), (3); UPDATE x SET i = i + 1; are there any plans to make this work? -- Roman Neuhauser -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Visual DATA editor for PostgreSQL?
Thanks, but seems Lightning Admin does not support foreign keys choice (at least, its demo version). Any other solutions? On Thu, Dec 31, 2009 at 10:47 AM, Tony Caduto < tony_cad...@amsoftwaredesign.com> wrote: > Dmitry Koterov wrote: > >> Hello. >> >> Is there a GUI utility to visually edit Postgres DATA (not a database >> schema!), which allows at least: >> - insert/update rows using screen windowed forms (possibly ugly >> auto-generated forms, but - still forms) >> - insert foreign key references by selecting them from a list (not by >> typing the keys manually) >> - work with multi-line text fields (textarea) for TEXT columns >> >> There is a lot of DB development tools around (e.g. I like EMS PostgreSQL >> Manager). But a developer tool is handy for a database STRUCTURE editing, >> and when we need to modify its DATA quickly, these tools are not too useful. >> > Lightning Admin has a form view when editing data and shows text fields as > multi line in the form view and in the data grid itself. > > Later, > > > Tony > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
Re: [GENERAL] pg_dump excluding tables content but not table schema
On Mon, 28 Dec 2009 21:20:17 +0100 Ivan Sergio Borgonovo wrote: > pg_dump -Fc -Z9 -s -t *.cache* -d mydb > schema_only.bak > pg_dump -Fc -Z9 -T *.cache* -d mydb > nearly_full.bak > cat nearly_full.bak schema_only.bak | pg_restore -1 -d mydb > It seems it is working... I'll test if everything is there. Unfortunately it doesn't work as expected. It silently skip to restore the second backup (schema_only.bak). I'm surprised it didn't output any error message, but the cache tables aren't there. It seems that you have to actually restore the 2 backup separately. pg_restore -1 -d mydb < nearly_full.bak pg_restore -1 -d mydb < schema_only.bak I can't think of any other way to restore both in one transaction unless I backup in plain text. But that should have other drawback. Any hint? -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Visual DATA editor for PostgreSQL?
Dmitry Koterov wrote: Hello. Is there a GUI utility to visually edit Postgres DATA (not a database schema!), which allows at least: - insert/update rows using screen windowed forms (possibly ugly auto-generated forms, but - still forms) - insert foreign key references by selecting them from a list (not by typing the keys manually) - work with multi-line text fields (textarea) for TEXT columns There is a lot of DB development tools around (e.g. I like EMS PostgreSQL Manager). But a developer tool is handy for a database STRUCTURE editing, and when we need to modify its DATA quickly, these tools are not too useful. Lightning Admin has a form view when editing data and shows text fields as multi line in the form view and in the data grid itself. Later, Tony -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgresql/postgis installation
Nick wrote: > Trying to install postgis on LINUX machine [...] > > during ./configure of postGIS errors out looking for geos-config > > during ./configure of geos errors out looking for g++ > > to the best of my knowledge g++ is part of gcc and we have a current > version of the gcc compiler on the computer > > More info...Linux distro RHEL5 and postgis version is 1.4.0. > Did a > > rpm -qa | grep gcc > > and gave me > > gcc-4.1.2-46el14.4.1 > > Thinking was that this included the g++, is that not the case? Or do > we need a version gcc-c++? Thanks, hope you can help. 'which g++' will convince you that there is indeed no g++ on your machine. You'll have to install gcc-c++ as you suspected. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
