use database administration software.
Thanks,
--
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com <http://www.enterprisedb.com/>)
On 12/10/06, *Philippe Salama* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Thanks for install link.
Can anyone recomme
Arnau a écrit :
Hi all,
I've got a DB in production that is bigger than 2GB that dumping it
takes more than 12 hours. I have a new server to replace this old one
where I have restore the DB's dump. The problem is I can't afford to
have the server out of business for so long, so I need your ad
Hi List,
I'm using postgresql 7.4 on FC4 linux.
i have one table named "purchase". it is working fine since 10 months but
suddenly from 3-4 days it creates problem.
when i'm fire a simple "select * from purchase" query on psql prompt,it
gives following error:
Invalid page header in block 211 of
Hello List,
I'm using postgresql 7.4 on FC4.
When i run following query on postgresql prompt, it gives error.
indse96=# CREATE TEMP TABLE aggregate AS ( SELECT vc_vouchno
,vc_srno,vc_type ,vc_vouchdt,trim(''),vc_descrip, ( CASE WHEN
(vc_dr_cr='D') THEN vc_amount ELS
in message
<[EMAIL PROTECTED]>, Steve Holdoway
<[EMAIL PROTECTED]> wrote:
On Mon, 13 Aug 2007 13:07:43 -0500
"Kevin Grittner" <[EMAIL PROTECTED]> wrote:
This gets me all the eye color codes that don't start with the letter 'B'.
(There are of course
rom many tables .
Thanks for help
Olivier
Kevin Grittner a écrit :
On Mon, Aug 13, 2007 at 4:30 PM, in message <[EMAIL PROTECTED]>,
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
So it's like a filter on the first query
Exactly; I think that su
It was
a frustrating experience... but makes sense when you think about
it. :) Good luck to you.
--
Alfred J. Fazio,
[EMAIL PROTECTED]
On Sep 6, 4:49 am, [EMAIL PROTECTED] ("gunce orman") wrote:
> hello,
>
> i have a partitioned table t_kayit with 6 partitions and kayit_id i
/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
8.1.x version ?
Olivier
Scott Marlowe a écrit :
On Dec 19, 2007 1:57 AM, olivier boissard <[EMAIL PROTECTED]> wrote:
Scott Marlowe a écrit :
On Dec 18, 2007 4:21 PM, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
Hello,
My purpose is to uses different query plan depen
Guillaume Lelarge a écrit :
[EMAIL PROTECTED] wrote:
You're right .
I will begin by migrate postgresql version.
postgresql is now to 8.3 version . A lot of performance inprovements
have been made in this last version .
In any case I must do a pg_dump/pg_restore.
So , Should I try dir
I am using postgres 8.2.6 on windows xp pro sp2. Of about 80 tables, one is a
large binary table containing over 2gb of data.
Postgres backsup the data and 95% of the time sticks at this table and cpu
activity drops from 40-60% to about zero. I can stay there for hours before I
just have to s
command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Firewall is turned off. I use zonealarm, but it is off. Windows firewall is
off.
I run pgadmin backup from the pc that is the postgres server. No client
applications are running during the backup.
The first 26 tables backup up nearly all the time before it gets to my large
table which comp
Pgsql-Admin subscribers,
I have problem about my Postrges95. There was no
problem before,
everything
was OK. But since some days ago I can't connect to my
database. The error
message is
"Could not connect to database (PQexec() -- Request was
sent to backend,
but
backend closed the channel befor
>Postrges95? for real? that is many versions back, an
upgrade is definatly>in order.
>
May be I will upgrade to Postgresql 6.4.2 someday.
But for now I have to recover this problem first.
>I don't know what to make of the below info, some sort
of db curruption>probably. Do you have a backup? fro
pg_dump -Dn databasename > mybackupdatabasename.sql
to restore:
create databasename_new
psql -e databasename_new < mybackupdatabasename_new.sql
more information man pg_dump
regards
On Fri, 2 Feb 2001 [EMAIL PROTECTED] wrote:
{Hi all,
{
{I going to cahge machine, but I need to make
what kind of error messages???
regards
On Fri, 2 Feb 2001, Ken Kinder wrote:
{Earlier last month I posted to this list about Postgres refusing to allow
{more insertions unless I dumped and recreated the database. I was asked to
{send a tarball next time it happened. I don't want to post it to
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I use postgresql 7.x on red hat 7.0
I use pgaccess and I have created new users with password
but when I want to open a database with a new user which normally needs a password, if
I don't assign the password, the database is open without it.
Why ?
_
I would like to make a connection from a client on my network to the database server
via TCP/IP.
What is the syntax ?
thanks
__
Voila vous propose une boite aux lettres gratuite sur Voila Mail:
http://mail.voila.fr
--
unregister YourEmailAddressHere" to [EMAIL PROTECTED])
I want to view events about my databases on a log file
In /var/lib/pgsql/data I have a log directory 'syslog' which contains no files
how can I do in order to have events in a file in this directory ?
Otherwise, what is the better method to view events in a log file ?
I have tryed to configure
my options in pg_options are:
verbose=2
query
hostlookup
showportnumber
syslog=2
what is the line I have to write in the /etc/syslog.conf in order to see events of
databases ?
__
Voila vous propose une boite aux lettres gratuite sur Voila Mail:
senet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Lamar Owen wrote
>How did you install -- from source, or from RPM?
I use postgresql 7.1 and I have installed it from RPM
__
Voila vous propose une boite aux lettres gratuite sur Voila Mail:
http://mail.voila.fr
---(end
elds, for the same data. :) " ?
{Ex:
{
{create table article (
{article text not null,
{article text not null,
{);
{
{?!??
{Bye.
{
{------
{FABIO SERRA - faser(at)faser.net
{PGP available
{--
{
{
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
hi all, i'm trying to do something like this:
CREATE FUNCTION read_table(text) RETURNS int AS '
DECLARE
table_name ALIAS FOR $1;
res
INTERGER;
BEGIN
SELECT INTO res COUNT(id) FROM table_name;
RETURN res;
END;
' LANGUAGE 'plpgsql';
using psql the c
I just suffered a hard drive failure and restored a database that had been
saved via pg_dump DATABASE >DATABASE.dump. However, instead of doing
pg_restore (which I completely forgot about :( ) ,
I did:
createdb DATABASE then I did
psql DATABASE
Hi! I just suffered a hard drive failure and restored a database that had been
saved via pg_dump DATABASE >DATABASE.dump. However, instead of doing
pg_restore (which I completely forgot about :( ) ,
I did:
createdb DATABASE then I did
psql DATABASE
Greetings.
I am having difficulty moving a SQL Server 2000 database over to
PostgreSQL 8.0.3.
In SQL Server, I am performing a backup of the database I want to move.
I save that backup on my Desktop.
I am then opening up PGAdminIII and attempting to perform a Restore of
the database saved
I have successfully moved the schema over to PostgreSQL.
Now I am working on the data.
In reviewing my tables, I found that for some strange reason a handful
of fields are not double-quoted. Strange quirk:
-- Table: "Orders"
-- DROP TABLE "Orders";
CREATE TABLE "Orders"
(
"OrderID" int4 N
Backup and Restore
selections are disabled (grayed out).
And so I'm a little stumped. Surely there is a workaround, but I have
yet to discover it.
Thanks in advance for any help you might be able provide.
Tom Lane wrote:
Ben Kim <[EMAIL PROTECTED]> writes:
In reviewing my tab
---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
#x27;orderid_id_seq'::text);
Jason
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, August 16, 2005 4:09 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] SQL Help - Obtaining ID of record INSERTED
Greetings.
INSERT INTO
I ran into a problem while compiling PGSQL 8.0.3. I am on Solaris 10
(Sparc) running GCC 4.0.
The problem is as follows:
gmake[4]: Leaving directory `/opt/sft/postgresql-8.0.3/src/port'
gmake[3]: Leaving directory `/opt/sft/postgresql-8.0.3/src/timezone'
gcc -O3 -pthreads -Wall -Wmissing-protot
[EMAIL PROTECTED] wrote:
>I ran into a problem while compiling PGSQL 8.0.3. I am on Solaris 10
>(Sparc) running GCC 4.0.
>
>The problem is as follows:
>
>
>gmake[4]: Leaving directory `/opt/sft/postgresql-8.0.3/src/port'
>gmake[3]: Leaving directory `/opt/sft/postgr
I'm using PostgreSQL 7.3.6 and run into a permissions problem when a
particular constraint trigger is attempting to restore using
pg_restore.
Is there a good way to analyze what permissions are required for a
particular constraint trigger? I have a problem where it looks like a
contraint trigger
I am having an extremely difficult time restoring the backup.gz I have
on my Desktop.
I just completed my installation of PG 8 on my Windows XP Home
notebook. I tried using PGAdminIII to do the Restore, but for some
reason it doesn't want to work.
So, I tried using PSQL, but I'm still not h
Hello to all ...
I'm trying to install a backup system for my Postgresql 8.1.1 (on windows xp)
using 3 wal files.
So i change these parameters in postgresql.conf
checkpoint_segments = 3
archive_command = 'copy "%p" "D:/PostgreSQL/backup/%f"'
I stop the database service and then restart it ...
B
taken from sunfreeware.com
Same config also worked with SOL9 (sparc)
--
<>< SALVATION -> http://www.rbc.org/odb/odb.shtml <><
- Original Message ----
From: Louis Gonzales <[EMAIL PROTECTED]>
To: Bruce Momjian
Cc: pgsql-admin@postgresql.org
Sent: Thursday,
exception is
java.sql.SQL
Exception: ERROR: No parser with id 17555
And the next one is from postgresql logs
$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data start
postmaster starting
[EMAIL PROTECTED] ~]$ LOG: database system was shut down at
2006-04-19 13:01:36UTC
LOG
hello,
I am trying to setup a "hot standby" on a second machine.
I have created a "recovery.conf" file and started a restore with logs
from the primary machine. everything was OK.
now a have new transaction logs generated by the primary machine and I
want to "play" them on the secondary one. I
Jyry Kuukkanen wrote:
On Thu, 4 May 2006, Rodrigo Sakai wrote:
Hi, I'm trying to do a backup of a database that is larger then 4 GB. But it gets an error when the file size gets 1.2 GB! I think its an Operational System problem (linux)! So, I want to know if exists some solution
Hi List,
I want to find out all the users under a specific user.
postgres is a superuser of postgresql,
under in postres user i made one user ABC and
under this ABC user i made XYZ,MNO,IJK users.
Now i want to find out all the users, which r exist
under in ABC user so what is the query for it?
Is there a way to do a selective pg_dump of a table using a select where
clause? As in ... dump all records where now-col_date < 2 or
col_date='01-may-2006' etc.. ?
Thanks
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
I am trying to move some data from an 8.0.7 instance to a 7.4.8
instance. I did a pg_dump and then did a pg_restore.
For the most part the data transferred through to the older instance but
I had problems with the sequence updates.
SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('nw_
In a function implemented in 7.4.8 I had the following error when I call
the function:
ERROR: syntax error at or near "EXCEPTION"
Offending line is:
EXCEPTION WHEN dup_val_on_index THEN NULL;
When this line is removed, all is well.
Any help appreciated...
---(end
Jaime Casanova wrote:
On 6/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
In a function implemented in 7.4.8 I had the following error when I call
the function:
ERROR: syntax error at or near "EXCEPTION"
Offending line is:
EXCEPTION WHEN dup_val_on_index THEN NULL;
Jim C. Nasby wrote:
On Mon, Jun 12, 2006 at 04:51:18PM -0400, [EMAIL PROTECTED] wrote:
I am trying to move some data from an 8.0.7 instance to a 7.4.8
instance. I did a pg_dump and then did a pg_restore.
For the most part the data transferred through to the older instance but
I
Jim C. Nasby wrote:
On Tue, Jun 13, 2006 at 04:28:47PM -0400, [EMAIL PROTECTED] wrote:
Does pg_get_serial_sequence() exist as plpgsql code? Where may I find
it? I would like to retrofit it into a 7.4.8 PG database.
No, but it shouldn't be terribly hard to do
Thanks!!!
I use ilike and I get the result that I want...
Thanks!
Regards!
Original Message:
-
From: Stephan Szabo [EMAIL PROTECTED]
Date: Mon, 04 Nov 2002 21:50:06 -0800 (PST)
To: [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Re: [ADMIN] About lower and
Thanks!!!
I use ilike and I get the result that I want...
Thanks!
Regards!
Original Message:
-
From: Stephan Szabo [EMAIL PROTECTED]
Date: Mon, 04 Nov 2002 21:50:06 -0800 (PST)
To: [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Re: [ADMIN] About lower and
now.
http://mailplus.yahoo.com
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
In Oracle you can look at the v$session view to get
session information and how long they have been
running. What is the equivalent in PostgreSQL?
TIA.
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.co
://mailplus.yahoo.com
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
o.com
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
nd of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I am trying to revoke the create table privilege from a user in a
database.
I have revoked create on database and on the public schema, yet I can
still create table as that user. what else do I need to do?
thanks,
signature
Jim
Bagley
Database Manager
Trader Electronic Media
(757) 3
|
md53175bce1d3201d16594cebf9d7eb3f9d | |
webdev | 103 | f | f | f |
md5980e74dba6ed3e28daccbc8d2150c9fb | |
thanks,
Jim
Bruno Wolff III wrote:
On Fri, Nov 07, 2003 at 15:47:50 -0500,
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote
the startup string you are using.
-
Marco Túlio Oliveira
IT-Manager
www.telecontrol.com.br
- Original Message -
From: "dojie pornea" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 13, 2003 11:39 AM
Subject: [A
In Oracle you can use cursors as columns. not sure if that will work
in postgresql. never tried it. =)
ex:
select name, curosr(select sum(quantity) from tablename where date
between(pick a date) and (pick another date)) as 01,
curosr(select sum(quantity) from tablename where date betw
I'm trying to install Postgresql-Redhat edition 3,0, but when they come you execute
the several tests begins them, I obtain a error:data directory check failed. I don't
understand the problem.i'm using RedHat 9.0A, from which I have removed all the
packages postgresql before trying the installat
help me!
I want see all field od this query:
SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,
pg_stat_get_backend_activity(s.backendid) AS current_query FROM (SELECT
pg_stat_get_backend_idset() AS backendid) s;
procpid | current_query
-+---
6449 |
6397 |
790
interactive/ssl-tcp.html) ?
Oh, I'm using PostgreSQL 8.0.8 on a Gentoo box. Maybe I have to upgrade
to another version?
Thans you in advance.
--
Sergio Cinos
Info3 Servicios Informáticos S.L.
[EMAIL PROTECTED] - www.info3.com
---(end of broadcast)--
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
70 matches
Mail list logo