Hello All,
I am having following PostgreSQL Linux version
PostgreSQL 8.2.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.3
20041212 (Red Hat 3.4.3-9.EL4)
I am trying to create the backupfile using gunzip utility
pg_dump qsweb | gzip /usr/local/backup/backup.gzBut when I run this
New to PG, just wondering if there's anyway to say.. I want t Full
backup of DB-Sample and I can just tar up the directory containing that
tablespace, copy it to another PG server and then re-attach it?
Thanks
---(end of broadcast)---
TIP 6:
Am Mittwoch, 1. August 2007 09:27 schrieb Ashish Karalkar:
pg_dump qsweb | gzip /usr/local/backup/backup.gzBut when I run this
command i get error stdin: not in gzip formattried with pg_dump qsweb |
gzip /usr/local/backup/backup.tar.gzbut same problem againCan any body
please suggest what is
Am Mittwoch, 1. August 2007 10:07 schrieb Ow Mun Heng:
New to PG, just wondering if there's anyway to say.. I want t Full
backup of DB-Sample and I can just tar up the directory containing that
tablespace, copy it to another PG server and then re-attach it?
No.
--
Peter Eisentraut
Ow Mun Heng wrote:
New to PG, just wondering if there's anyway to say.. I want t Full
backup of DB-Sample and I can just tar up the directory containing that
tablespace, copy it to another PG server and then re-attach it?
No. Apart from anything else OID and transaction numbers would be all
Ashish Karalkar wrote:
I am trying to create the backupfile using gunzip utility
pg_dump qsweb | gzip /usr/local/backup/backup.gzBut when I run this
command i get error stdin: not in gzip formattried with pg_dump qsweb
| gzip /usr/local/backup/backup.tar.gzbut same problem againCan any
body
Le mardi 31 juillet 2007, Mike Haberman a écrit :
My old database has the old-style FOREIGN KEY syntax:
I've had this very same transition to make on a database here, and
successfully used adddepend:
http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/adddepends/adddepends/
It has been moved out
On Friday 27 July 2007 Alvaro Herrera's cat, walking on the keyboard, wrote:
Consider an open cursor; you open it and leave it there. Then you
delete something from the table. Then you read from the cursor. The
deleted row must be in the cursor.
Thanks fot these details. Now a few other
Luca Ferrari [EMAIL PROTECTED] writes:
Thanks fot these details. Now a few other questions come into my mind (I hope
not to bother you guys!).
In chapter 49 of the documentation (index access) I read that an index stores
pointers to any version of the tuple that is present in the
On Wednesday 1 August 2007 Gregory Stark's cat, walking on the keyboard,
wrote:
You're right, the index contains pointers to *every* version of the tuple.
So in a regular SELECT statement you don't need to look at the update chain
at all.
The main use of the update chain is when you want to
Paolo, I started with linux 6 years ago after being a confirmed
microsoftie my entire career, this is the experience I can offer:
Ubuntu: What Windows wants to be, what the Mac is w/o the and with
more control. I just replaced a hard drive in a dell machine. A
generic windows CD (the
Tom Lane wrote:
You'd have to cast the NULL to some specific array type.
regards, tom lane
Unfortunately I can't do that (well, in fact it would be pretty
inconvenient) because the function is called from other plpgsql function
and I cannot be sure if it will be called with NULL or not.
On 01.08.2007 13:29, [EMAIL PROTECTED] wrote:
I bought a Dell server and I am going to use it for installing PostgrSQL
8.2.4. I always used Windows so far and I would like now to install a
Linux distribution on the new server. Any suggestion on which distribution
? Fedora, Ubuntu server, Suse or
Hello,
I bought a Dell server and I am going to use it for installing PostgrSQL
8.2.4. I always used Windows so far and I would like now to install a
Linux distribution on the new server. Any suggestion on which distribution
? Fedora, Ubuntu server, Suse or others?
Thanks in advance,
Paolo
[EMAIL PROTECTED] wrote:
Hello,
I bought a Dell server and I am going to use it for installing PostgrSQL
8.2.4. I always used Windows so far and I would like now to install a
Linux distribution on the new server. Any suggestion on which distribution
? Fedora, Ubuntu server, Suse or others?
On Wed, 2007-08-01 at 13:29 +0200, [EMAIL PROTECTED] wrote:
Hello,
I bought a Dell server and I am going to use it for installing PostgrSQL
8.2.4. I always used Windows so far and I would like now to install a
Linux distribution on the new server. Any suggestion on which distribution
?
Hi,
How do I connect postgres table structures and view structures to an
existing svn repository?
Thanks,
--
John J. Mitchell
[EMAIL PROTECTED] wrote:
Hello,
I bought a Dell server and I am going to use it for installing PostgrSQL
8.2.4. I always used Windows so far and I would like now to install a
Linux distribution on the new server. Any suggestion on which distribution
? Fedora, Ubuntu server, Suse or others?
On Wed, 1 Aug 2007, [EMAIL PROTECTED] wrote:
I bought a Dell server and I am going to use it for installing PostgrSQL
8.2.4. I always used Windows so far and I would like now to install a
Linux distribution on the new server. Any suggestion on which
distribution ? Fedora, Ubuntu server, Suse
I'm about to install a new Linux server, and I've followed this thread
with interest, being a tinkerer rather than any sort of expert.
I'm going to try out Debian, which I haven't used before - the server
it's replacing is running an old RedHat - and would be interested in
people's comments.
Hi,
I am trying to store schema definitions in version-control which I can do by
saving the definition and then importing into svn, but I would like it
to be automatic , so that when an update occurs to a table or view within
postgres then that table or view is flagged within svn. This would
-Messaggio originale-
Da: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Per conto di Reid Thompson
Inviato: mercoledì 1 agosto 2007 15.15
A: [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Oggetto: Re: [GENERAL] Linux distro
On Wed, 2007-08-01 at 13:29 +0200, [EMAIL PROTECTED] wrote:
On 8/1/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello,
I bought a Dell server and I am going to use it for installing PostgrSQL
8.2.4. I always used Windows so far and I would like now to install a
Linux distribution on the new server. Any suggestion on which distribution
? Fedora,
John Mitchell schrieb:
Hi,
How do I connect postgres table structures and view structures to an
existing svn repository?
Please elaborate: what do you mean with connect?
If you want to version control your DDL, people
use pgdump to create individual dumps (as sql
text files) and just
I'm having a problem, and can't seem to find a good answer in the mailing
list archives... sorry if I'm missing something obvious!
Postgres version: 8.2.4
O/S: Solaris 10
I want to set a BOOLEAN column value to FALSE by default for all INSERT and
UPDATE statements performed against a particular
On Wednesday 1. August 2007 16:15, Madison Kelly wrote:
/Personally/, I love Debian on servers.
It's not quite as 'hardcore' as Gentoo (a great distro, but not one to
start with!). It's the foundation of many of the popular distros
(Ubuntu, Mepis, Knoppix, etc) and the Debian crew is very
John Mitchell wrote:
I am trying to store schema definitions in version-control which I can do by
saving the definition and then importing into svn, but I would like it
to be automatic , so that when an update occurs to a table or view within
postgres then that table or view is flagged
At 4:52 PM +0200 8/1/07, Leif B. Kristensen wrote:
On Wednesday 1. August 2007 16:15, Madison Kelly wrote:
/Personally/, I love Debian on servers.
It's not quite as 'hardcore' as Gentoo (a great distro, but not one to
start with!). It's the foundation of many of the popular distros
(Ubuntu,
Raymond O'Donnell wrote:
I'm about to install a new Linux server, and I've followed this thread
with interest, being a tinkerer rather than any sort of expert.
I'm going to try out Debian, which I haven't used before - the server
it's replacing is running an old RedHat - and would be
wow.. Thank you.
mike
On Wed, Aug 01, 2007 at 10:31:16AM +0200, Dimitri Fontaine wrote:
Le mardi 31 juillet 2007, Mike Haberman a ?crit?:
My old database has the old-style FOREIGN KEY syntax:
I've had this very same transition to make on a database here, and
successfully used
Looking to capture the total number of records affected with
insert/delete/update from within a plpgsql (v7.4 on linux). Would be
nice to have this in an integer.
Thanks
-dave
Perhaps
rowcnt integer;
...
get diagnostics rowcnt := row_count;
???
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Gauthier, Dave
Sent: Wednesday, August 01, 2007 12:05 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] how
I just moved one of my desktops and my laptop from Fedora 6 to Unbuntu
7.04 because Fedora lacked hardware support that Unbuntu and my Fedora
machines had all sorts of problems like sound dropping out and machines
locking up. (Also the Fedora installers are terrible).
My small gripes about
On Wednesday 1. August 2007 18:05, Gauthier, Dave wrote:
Looking to capture the total number of records affected with
insert/delete/update from within a plpgsql (v7.4 on linux). Would be
nice to have this in an integer.
http://www.varlena.com/GeneralBits/23.php
8-
How many rows were
charlie derr napisal 2007-08-01 17:37:
I would include the following as legitimate reasons to want to
build from source:
2. You need features from a newer version than is available in Debian.
Martin Pitt - Debian's PostgreSQL package maintainer makes a great job.
You won't wait too
Joseph S [EMAIL PROTECTED] writes:
My small gripes about Ubuntu are:
1) rpm, for all its faults, is still better than using apt
You *must* be joking. In Debian and Ubuntu, I've never had a tenth of
the dependency hell that you regularly hit with RPMs (though yum has
improved things
On 8/1/07, Douglas McNaught [EMAIL PROTECTED] wrote:
Joseph S [EMAIL PROTECTED] writes:
My small gripes about Ubuntu are:
1) rpm, for all its faults, is still better than using apt
You *must* be joking. In Debian and Ubuntu, I've never had a tenth of
the dependency hell that you
Joseph S wrote:
I just moved one of my desktops and my laptop from Fedora 6 to Unbuntu
7.04 because Fedora lacked hardware support that Unbuntu and my Fedora
machines had all sorts of problems like sound dropping out and machines
locking up. (Also the Fedora installers are terrible).
My
Brian Mathis [EMAIL PROTECTED] writes:
Please don't start this. These issues are exactly why one should be
looking at an ENTERPRISE OS for a server. Fedora, ubuntu, etc... are
not enterprise OSes, and any discussion of such issues are certainly
off-topic for this mailing list. An
On Wed, 1 Aug 2007, Joseph S wrote:
My small gripes about Ubuntu are:
1) rpm, for all its faults, is still better than using apt
This is drfiting off-topic for this list, but this statement is so odd I
can't let it go unchallenged. You must have some odd criteria for
better or run into
On 8/2/07, Reid Thompson [EMAIL PROTECTED] wrote:
If it's a dedicated production server, look at UBUNTU 6.10 server.
If you're planning to connect a monitor and run X-windows ( i.e. I
bought a server, but i'm going to use it as a learning platform for
LINUX in general also), i'd suggest
On 8/2/07, Rich Shepard [EMAIL PROTECTED] wrote:
Andrej,
Richard,
How quickly people forget about the quiet distribution: Slackware. Ideal
for servers, and great on desktops and portables, too, for those who know
what they're doing.
Slackware is my preferred distro by a long stretch, I've
On 8/1/07, Madison Kelly [EMAIL PROTECTED] wrote:
Joseph S wrote:
I just moved one of my desktops and my laptop from Fedora 6 to Unbuntu
7.04 because Fedora lacked hardware support that Unbuntu and my Fedora
machines had all sorts of problems like sound dropping out and machines
locking
On 06:30 Thu 02 Aug , Andrej Ricnik-Bay wrote:
On 8/2/07, Rich Shepard [EMAIL PROTECTED] wrote:
Andrej,
Richard,
How quickly people forget about the quiet distribution: Slackware. Ideal
for servers, and great on desktops and portables, too, for those who know
what they're
Please forgive me if this question is being asked in the wrong area (and
please suggest the proper one so I can ask there :-) ), but I'm in search of
assistance in moving a database from a Solaris system over to a Windows
system.
Solaris 5.8, postgreSQL 8.01, to Windows Server 2003, postgreSQL
You asked for details, here's a few:
The database that I'm working with on the Solaris side is approximately
1.5GB in size. One file in the directory that I believe is that database,
is over 1GB in size on it's own.
When I tried using the plain format, I got human readable information which
is
On Aug 1, 2007, at 2:34 PM, Steve Atkins wrote:
On Aug 1, 2007, at 11:44 AM, Barry C Dowell wrote:
Please forgive me if this question is being asked in the wrong
area (and
please suggest the proper one so I can ask there :-) ), but I'm in
search of
assistance in moving a database from a
On Aug 1, 2007, at 11:44 AM, Barry C Dowell wrote:
Please forgive me if this question is being asked in the wrong area
(and
please suggest the proper one so I can ask there :-) ), but I'm in
search of
assistance in moving a database from a Solaris system over to a
Windows
system.
On Wed, 2007-08-01 at 13:29 +0200, [EMAIL PROTECTED] wrote:
Hello,
I bought a Dell server and I am going to use it for installing PostgrSQL
8.2.4. I always used Windows so far and I would like now to install a
Linux distribution on the new server. Any suggestion on which distribution
?
Ok, if you can forgive the possible stupid answer and help pull me a long a
bit more, in answer to this:
Yes, dump/restore is pretty much the standard to move dbs across
architectures so we'll need more to work with. One thing to check, did you
make sure that your dump was in the same encoding
On 8/2/07, John K Masters [EMAIL PROTECTED] wrote:
I love Slackware but have eventually gone back to running my servers on
Debian stable. Most of the Debian derivatives base on unstable to get
the latest version of things but stable is rock solid and will never let
you down. The advantage of
On a 8.1.9 version database that has been recently vacuumed and
analyzed, I'm seeing some dramatic performance degradation if a limit
clause is included in the query. This seems counter-intuitive to me.
Here's the query and explain plan WITH the LIMIT clause:
SELECT *
FROM topic_feed
WHERE
On 09:15 Thu 02 Aug , Andrej Ricnik-Bay wrote:
On 8/2/07, John K Masters [EMAIL PROTECTED] wrote:
I love Slackware but have eventually gone back to running my servers on
Debian stable. Most of the Debian derivatives base on unstable to get
the latest version of things but stable is
On Wed, 2007-08-01 at 15:56 -0500, Mason Hale wrote:
On a 8.1.9 version database that has been recently vacuumed and
analyzed, I'm seeing some dramatic performance degradation if a limit
clause is included in the query. This seems counter-intuitive to me.
Here's the query and explain plan
Andrej Ricnik-Bay wrote:
On 8/2/07, Reid Thompson [EMAIL PROTECTED] wrote:
If it's a dedicated production server, look at UBUNTU 6.10 server.
If you're planning to connect a monitor and run X-windows ( i.e. I
bought a server, but i'm going to use it as a learning platform for
LINUX in
Jeff Davis [EMAIL PROTECTED] writes:
On Wed, 2007-08-01 at 15:56 -0500, Mason Hale wrote:
SELECT *
FROM topic_feed
WHERE topic_id = 106947234
ORDER BY score DESC
LIMIT 25
In plan 1, the planner thinks that it will find 25 tuples matching that
topic_id quickly during the backwards index
On 8/1/07, Mason Hale [EMAIL PROTECTED] wrote:
On a 8.1.9 version database that has been recently vacuumed and
analyzed, I'm seeing some dramatic performance degradation if a limit
clause is included in the query. This seems counter-intuitive to me.
Here's the query and explain plan WITH the
On Wed, 1 Aug 2007, Scott Marlowe wrote:
On 8/1/07, Mason Hale [EMAIL PROTECTED] wrote:
On a 8.1.9 version database that has been recently vacuumed and
analyzed, I'm seeing some dramatic performance degradation if a limit
clause is included in the query. This seems counter-intuitive to
On 8/2/07, Ron Johnson [EMAIL PROTECTED] wrote:
As an alternative viewpoint, I've been running the latest postgres on
Mac OS X Server 10.4, and it's been great for me. It was my first time
using a server, and my first serious use of postgres (although I have
had a lot of previous unix
Work is beginning on pgsnmpd v 2.0, and I figured it would be a good
time to ask folks what they typically like to monitor, so we can make
sure pgsnmpd instruments it properly. The current version of pgsnmpd
supports something called RDBMS-MIB, which is a set of data designed
to be applicable to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/01/07 10:37, Owen Hartnett wrote:
At 4:52 PM +0200 8/1/07, Leif B. Kristensen wrote:
On Wednesday 1. August 2007 16:15, Madison Kelly wrote:
/Personally/, I love Debian on servers.
It's not quite as 'hardcore' as Gentoo (a great distro,
Let's call those plan 1 and plan 2.
In plan 1, the planner thinks that it will find 25 tuples matching that
topic_id quickly during the backwards index scan on
topic_feed_score_index. Instead, it looks like it has to go through a
lot of tuples before it finds the necessary 25.
In plan 2,
On 8/2/07, Barry C Dowell [EMAIL PROTECTED] wrote:
Ok, if you can forgive the possible stupid answer and help pull me a long a
bit more, in answer to this:
Yes, dump/restore is pretty much the standard to move dbs across
architectures so we'll need more to work with. One thing to check, did
On 8/1/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello,
I bought a Dell server and I am going to use it for installing PostgrSQL
8.2.4. I always used Windows so far and I would like now to install a
Linux distribution on the new server. Any suggestion on which distribution
? Fedora,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/01/07 21:44, Andrej Ricnik-Bay wrote:
On 8/2/07, Ron Johnson [EMAIL PROTECTED] wrote:
As an alternative viewpoint, I've been running the latest postgres on
Mac OS X Server 10.4, and it's been great for me. It was my first time
using a
On 8/2/07, Ron Johnson [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/01/07 10:37, Owen Hartnett wrote:
At 4:52 PM +0200 8/1/07, Leif B. Kristensen wrote:
On Wednesday 1. August 2007 16:15, Madison Kelly wrote:
/Personally/, I love Debian on servers.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/01/07 21:58, Merlin Moncure wrote:
[snip]
3. binary packaging
While I like the debian distros generally, I dislike the debian
packaging of PostgreSQL. IMO, it's over engineered. If you plan to
How so?
- --
Ron Johnson, Jr.
Jefferson LA
On 8/2/07, Merlin Moncure [EMAIL PROTECTED] wrote:
A server with a GUI sitting on a login screen is wasting zero
resources. Some enterprise management tools are in java which require
a GUI to use so there is very little downside to installing X, so IMO
a lightweight window manager is
Andrej Ricnik-Bay escribió:
On 8/2/07, Merlin Moncure [EMAIL PROTECTED] wrote:
A server with a GUI sitting on a login screen is wasting zero
resources. Some enterprise management tools are in java which require
a GUI to use so there is very little downside to installing X, so IMO
a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/01/07 22:05, Merlin Moncure wrote:
On 8/2/07, Ron Johnson [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/01/07 10:37, Owen Hartnett wrote:
At 4:52 PM +0200 8/1/07, Leif B. Kristensen wrote:
On Wednesday 1.
On 8/2/07, Alvaro Herrera [EMAIL PROTECTED] wrote:
PID USER PR NI VIRT RES SHR S %CPU %MEMTIME+ COMMAND
4735 root 18 0 52524 7204 4304 S 0.0 0.4 0:00.01 httpd
4820 root 15 0 141m 6648 3140 S 0.0 0.4 0:00.64 X
I think most of the virtual memory used
I already put the data directory on hds san storage, but there is no
snapshot license on it.
Could I use mksnap_ffs under freebsd to make snapshot for backup ?
---(end of broadcast)---
TIP 6: explain analyze is your friend
72 matches
Mail list logo