Hi,
I have a question that if a partition can be loaded from a file?
A table in the database is partitioned, and each partition is saved to
a separate tablespace, so each located in a separate directory. We want to
transfer the data in a specific partition (a directory with files in it)
On 11/01/12 12:48 AM, zhangbonian wrote:
I have a question that if a partition can be loaded from a file?
A table in the database is partitioned, and each partition is saved to
a separate tablespace, so each located in a separate directory. We
want to transfer the data in a specific partition
On 11/01/2012 02:25 AM, Mike Christensen wrote:
It would also matter what columns were next to it, correct?
It doesn't look like PostgreSQL packs booleans. It still matters what's
next to it because of the alignment requirements of other data types,
but you still have a minimum of one byte per
Sorry there isn't a README.Debian.gz in the postgresql-doc-9.1. There is a
changelog.Debian.gz but that doesn't seem to address this problem.
From: Craig Ringer [mailto:ring...@ringerc.id.au]
Sent: Thursday, November 01, 2012 12:33 AM
To: Kevin Burton
Cc: pgsql-general@postgresql.org
Subject:
There is a tutorial directory but it has a README that I need to type 'make'
to view the files. Well, make wasn't available so I installed 'make' with
apt-get. Then I was met with an error apparently from the Makefile that
pg_conf: command not found. I seem to be getting farther and farther from
On 11/01/2012 05:02 AM, Kevin Burton wrote:
There is a tutorial directory but it has a README that I need to type 'make'
to view the files. Well, make wasn't available so I installed 'make' with
apt-get. Then I was met with an error apparently from the Makefile that
pg_conf: command not found. I
Dpkg -l | grep postgresql shows
postgresql-9.1
postgresql-common
postgresql-client-common
postgresql-doc
postgresql-doc-9.1
Ps -ax | grep postgresql shows
Postgresql
I still get ' psql: FATAL: role postgres does not exist' when I execute
'sudo -u postgres psql'.
On 11/01/2012 06:38 AM, Kevin Burton wrote:
Dpkg -l | grep postgresql shows
postgresql-9.1
postgresql-common
postgresql-client-common
postgresql-doc
postgresql-doc-9.1
Ps -ax | grep postgresql shows
Postgresql
Please show the actual output from the ps command.
On Wed, Oct 31, 2012 at 8:08 PM, Raghavendra
raghavendra@enterprisedb.com wrote:
False represented by zero bytes and True by 1 byte with value 1.
This is not true AFAIK. Both boolean TRUE and FALSE values require 1 byte.
A NULL value is zero bytes (though it still consumes 1 bit in the null
I am having a hard time with the clipboard so I will reproduce the output as
best as I can:
2066 tty1 S+ 0:00 grep --color=auto postgresql
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Thursday, November 01, 2012 8:42 AM
To: Kevin Burton
Cc: 'Joshua D.
If you change the grep to postgres then there are a number of entries (about
17). The output since I don't have a clipboard is too much to try and type
in by hand.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Kevin
On 11/01/2012 06:45 AM, Kevin Burton wrote:
I am having a hard time with the clipboard so I will reproduce the output as
best as I can:
2066 tty1 S+ 0:00 grep --color=auto postgresql
So Postgres is not actually running. What you are seeing is the grep command.
If it where running you would
Adrian Klaver wrote:
What does ps ax| grep postgresql show?
Are you sure you don't want this?:
ps ax | grep postgres
-Kevin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, Nov 2, 2012 at 12:51 AM, Kevin Burton rkevinbur...@charter.net wrote:
If you change the grep to postgres then there are a number of entries (about
17). The output since I don't have a clipboard is too much to try and type
in by hand.
Try this:
ps ax| grep postgresql processes.txt
On Fri, Nov 2, 2012 at 12:56 AM, Chris Angelico ros...@gmail.com wrote:
On Fri, Nov 2, 2012 at 12:51 AM, Kevin Burton rkevinbur...@charter.net
wrote:
If you change the grep to postgres then there are a number of entries (about
17). The output since I don't have a clipboard is too much to try
On 11/01/2012 06:51 AM, Kevin Burton wrote:
If you change the grep to postgres then there are a number of entries (about
17). The output since I don't have a clipboard is too much to try and type
in by hand.
If you are seeing the above in a terminal then use the mouse to select
the area and
On 10/31/2012 12:59 PM, cr...@gtek.biz wrote:
list all role privileges
Google:
site:archives.postgresql.org 'list all role privileges'
--
I was kind of hoping The world's most advanced open source database. would
offer this functionality without having to rely on an outside source.
Hey guys,
I don't notice any errors, which just makes this even more strange. But
after weeks of operating normally, our 10pm manual vacuum job generated
transaction logs basically equivalent to 3/4 of our database, and I
can't find any explanation. This amount is about 6x higher than usual.
Hi Jürgen,
am 31.10.2012 um 15:24 schrieb Jürgen Fuchsberger
juergen.fuchsber...@uni-graz.at:
The replica is backed up once a week using rsync, a full backup runs about 10
hours, so I also keep at least 24h of WAL files to make sure I have a
consistent backup.
The backup process also
I put the mouse in the command window and I don't see anything getting
selected.
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Thursday, November 01, 2012 8:58 AM
To: Kevin Burton
Cc: 'Joshua D. Drake'; pgsql-general@postgresql.org
Subject: Re: [GENERAL]
Yes. This is what I did. It shows a number of entries but I cannot get the
clipboard to work so for now I cannot detail all of the entries.
-Original Message-
From: Kevin Grittner [mailto:kgri...@mail.com]
Sent: Thursday, November 01, 2012 8:51 AM
To: Adrian Klaver; Kevin Burton
Cc:
On Fri, Nov 2, 2012 at 1:06 AM, Kevin Burton rkevinbur...@charter.net wrote:
If I use vi as my editor how do I copy the text to the clipboard?
I would recommend picking an editor that matches the way you post to
the list. For example, I use webmail with a GUI web browser, so the
editor that I'd
I am not running on multiple machines. I think that initdb or something like
it was not installed so it when I tried to invoke it Iwas met with an error
that initdb is in the postgres-xc package and then told me how to install
it. Not having known that postgres-xc is clustering software I just did
Shaun Thomas wrote:
I don't notice any errors, which just makes this even more strange.
But after weeks of operating normally, our 10pm manual vacuum job
generated transaction logs basically equivalent to 3/4 of our
database, and I can't find any explanation. This amount is about 6x
higher
I am not working on the same machine that I read email from. The machine
that has the Linux Server on it has no GUI installed.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Chris Angelico
Sent: Thursday, November 01,
On Fri, Nov 2, 2012 at 1:18 AM, Kevin Burton rkevinbur...@charter.net wrote:
I am not working on the same machine that I read email from. The machine
that has the Linux Server on it has no GUI installed.
In that case, two options:
1) Copy and paste from your SSH session locally
2) Transfer the
On 11/01/2012 09:18 AM, Kevin Grittner wrote:
Did you bulk load this data (possibly through restoring pg_dump
output)? If so, and you have not explicitly run VACUUM FREEZE
afterward, the vacuum noticed that it was time to freeze all of these
tuples.
Ok, that might explain it, then. We did in
On Fri, Nov 2, 2012 at 1:02 AM, cr...@gtek.biz wrote:
On 10/31/2012 12:59 PM, cr...@gtek.biz wrote:
list all role privileges
Google:
site:archives.postgresql.org 'list all role privileges'
--
I was kind of hoping The world's most advanced open source database. would
offer this
On 11/01/2012 07:16 AM, Kevin Burton wrote:
I am not running on multiple machines. I think that initdb or something like
it was not installed so it when I tried to invoke it Iwas met with an error
that initdb is in the postgres-xc package and then told me how to install
it. Not having known that
The version of Ubuntu is 12.10.
I am not sure what version of PostgreSQL it install but it is now 9.1
No other packages were installed (I installed 'make' to try and see the
documentation).
So how do I uninstall postgreSQL-XC if that is the problem?
-Original Message-
From: Adrian
On 11/01/2012 07:38 AM, Kevin Burton wrote:
The version of Ubuntu is 12.10.
I am not sure what version of PostgreSQL it install but it is now 9.1
No other packages were installed (I installed 'make' to try and see the
documentation).
So how do I uninstall postgreSQL-XC if that is the problem?
I had to install postgresql-client-common and postgresql-client-9.1 to get
psql it said that psql was in postgresql-client-common AND postgresql-xc.
Now that I know to avoid 'xc' I choose the common and rebooted. Then I tried
to run psql and I was met with an error that at least one of
I also tried 'initdb' and I get an error 'The program initdb is currently
not installed. You can install it by typing: sudo apt-get install
postgres-xc'. I didn't do anything since that led to the earlier problem.
-Original Message-
From: pgsql-general-ow...@postgresql.org
On 11/01/2012 08:06 AM, Kevin Burton wrote:
I had to install postgresql-client-common and postgresql-client-9.1 to get
psql it said that psql was in postgresql-client-common AND postgresql-xc.
Now that I know to avoid 'xc' I choose the common and rebooted. Then I tried
to run psql and I was met
Sudo -u postgres psql - now works!! Thank you. Now how do I add a role so
that I don't have to use sudo?
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Thursday, November 01, 2012 10:13 AM
To: Kevin Burton
Cc: 'Joshua D. Drake'; pgsql-general@postgresql.org
This is probably a question for the authors of a book I have been reading
but it may be faster to get an answer here.
I was trying to follow along in a book 'Seven Databases in Seven Weeks' and
chapter 2 deals with PostgreSQL. One of the first things it does is issue a
command 'createdb book'.
Kevin Burton wrote:
how do I add a role [...] ?
http://www.postgresql.org/docs/9.2/interactive/database-roles.html
-Kevin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Nov 1, 2012 at 4:32 PM, Kevin Burton rkevinbur...@charter.netwrote:
This is probably a question for the authors of a book I have been reading
but it may be faster to get an answer here.
** **
I was trying to follow along in a book ‘Seven Databases in Seven Weeks’
and chapter 2
Torsdag 1. november 2012 16.32.42 skrev Kevin Burton :
This is probably a question for the authors of a book I have been reading
but it may be faster to get an answer here.
I was trying to follow along in a book 'Seven Databases in Seven Weeks' and
chapter 2 deals with PostgreSQL. One
I type 'find createdb' and I get an error find: 'createdb' no such file or
directory.
From: Magnus Hagander [mailto:mag...@hagander.net]
Sent: Thursday, November 01, 2012 10:38 AM
To: Kevin Burton
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Where is 'createdb'?
On Thu, Nov
Shaun Thomas wrote:
Ok, that might explain it, then. We did in fact just upgrade from 8.2 to
9.1 about 2 weeks ago. And no, I didn't do a VACUUM FREEZE, just a
VACUUM ANALYZE to make sure stats were ready. I'm still a little
uncertain what the tangible difference is between a FREEZE and a
should have given the full output earlier
pkumar@ulinux1:~$ sudo su - postgres[sudo] password for pkumar:
postgres@ulinux3:~$ createdb authDBpostgres@ulinux3:~$ createuser -P -l
authuserEnter password for new role: Enter it again: Shall the new role be a
superuser? (y/n) ypostgres@ulinux3:~$
Now I get psql: FATAL: role kevin is not permitted to log in
-Original Message-
From: Kevin Grittner [mailto:kgri...@mail.com]
Sent: Thursday, November 01, 2012 10:31 AM
To: Kevin Burton; Adrian Klaver
Cc: Joshua D. Drake; pgsql-general@postgresql.org
Subject: Re: [GENERAL] role does not
You're using find in your current working directory. It seems you may need
an introduction to find for Ubuntu (based on your other thread it seems
you're using PostgreSQL 9.1 on Ubuntu):
https://help.ubuntu.com/community/find
On Thu, Nov 1, 2012 at 8:41 AM, Kevin Burton
What version of PostgreSQL did you install and how did you install it? I
have 9.2.1 and it installed createdb into the default /usr/bin/ path, as
did 9.1 and 9.0 before it (installed via yum in my case).
On Thu, Nov 1, 2012 at 8:32 AM, Kevin Burton rkevinbur...@charter.netwrote:
This is
On 11/01/2012 08:41 AM, Kevin Burton wrote:
I type 'find createdb' and I get an error find: 'createdb' no such
file or directory.
Which exact OS/distribution/PostgreSQL-version are you using and how was
PostgreSQL installed (OS-provided or 3rd-party)? The different packagers
deal with
On 11/01/2012 10:28 AM, Kevin Grittner wrote:
http://www.postgresql.org/docs/9.2/interactive/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND
I read that several times, and I still don't get how it applies to this
case. Based on my past experience with 8.2, and my understanding of 9.1,
I moved
Le jeudi 01 novembre 2012 à 10:21 -0500, Kevin Burton a écrit :
Sudo -u postgres psql - now works!! Thank you. Now how do I add a role so
that I don't have to use sudo?
http://www.postgresql.org/docs/9.1/static/app-createuser.html
--
Vincent Veyron
http://marica.fr/
Logiciel de gestion
Hello.
Why adding FK creates AccessExclusiveLock on referenced tabble?
{{{
CREATE TABLE A ( id integer, idb integer );
INSERT INTO A (id,idb) SELECT x, x%4 FROM generate_series(1,100) x;
CREATE TABLE B ( id int primary key );
INSERT INTO B VALUES (0),(1),(2),(3);
BEGIN;
ALTER TABLE A ADD
On 1 November 2012 17:19, Shaun Thomas stho...@optionshouse.com wrote:
On 11/01/2012 10:28 AM, Kevin Grittner wrote:
Based on my past experience with 8.2, and my understanding of 9.1, I
moved autovacuum_freeze_max_age up to 650M so we'd never get a mid-day
freeze. And the default for
On 11/01/2012 11:40 AM, Alban Hertroys wrote:
Instead of attempting to postpone freeze until beyond the life
expectancy of our universe, what you probably should have done is
vacuum more often so that vacuum has less work to do.
More often than every night, with autovacuum running in the
If I use vi as my editor how do I copy the text to the clipboard?
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Chris Angelico
Sent: Thursday, November 01, 2012 8:57 AM
To: pgsql-general@postgresql.org
Subject: Re:
I'm making this post here in hopes I may save someone from beating
their head against the wall like I did...
I am writing a custom Name Service Switch (NSS) module to take
advantage of already existing account information in a pg database.
Under certain circumstances, processes will hang due to
Here is what i did on a Ubuntu linux server. I had installed postgres using
apt-get install postgres.
pkumar@ulinux1:~$ sudo su - postgres[sudo] password for pkumar:
postgres@ulinux3:~$ createdb authDBpostgres@ulinux3:~$ createuser -P -l authuser
You have to sudo into postgres or fix your
On Fri, Nov 2, 2012 at 2:37 AM, Magnus Hagander mag...@hagander.net wrote:
On Thu, Nov 1, 2012 at 4:32 PM, Kevin Burton rkevinbur...@charter.net
wrote:
The text before this command says, “Once
you have Postgres installed, create a schema called book using the following
command: $ createdb
I do see actually three lines with a -D in it that may be similar:
1166 ? S 0:01 /usr/bin/postgres -C -D /var/lib/postgres-xc/coord
1214 ? S 0:01 /usr/bin/postgres -X -D /var/lib/postgres-xc/datanode1
1233 ? S 0:01 /usr/bin/postgres -X -D /var/lib/postgres-xc/datanode2
There are a number of
Hello Team,I'm working on a project that uses PostgreSQL 8.3. We are
planning a Java 7 and I would like to ask If we can use same vesion or should
we upgarde to the latest? Thanks in advance!
I would say upgrade to the latest. There are features and performance
increases in the 9.x series.
Randall Svancara
High Performance Computing Systems Administrator
Washington State University
509-335-3039
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On
We are using a third party monitoring solution called Zabbix with Postgresql
9.1.We are observing lots of sharelock problems possibly as a result of
multiple, concurrent updates to the specific table called items.
First of all, what can I do to reduce lock contention in Postgresql? Surely
2012-11-01 16:32 keltezéssel, Kevin Burton írta:
This is probably a question for the authors of a book I have been reading but it may be
faster to get an answer here.
I was trying to follow along in a book 'Seven Databases in Seven Weeks' and chapter 2
deals with PostgreSQL. One of the
On 11/01/2012 07:00 AM, Kevin Burton wrote:
I do see actually three lines with a -D in it that may be similar:
1166 ? S 0:01 /usr/bin/postgres -C -D /var/lib/postgres-xc/coord
1214 ? S 0:01 /usr/bin/postgres -X -D /var/lib/postgres-xc/datanode1
1233 ? S 0:01 /usr/bin/postgres -X -D
On 11/01/2012 02:10 PM, Boszormenyi Zoltan wrote:
2012-11-01 16:32 keltezéssel, Kevin Burton írta:
...I get 'createdb command not found'. Are the authors out of date?
What is the current command?
The instructions start with Once you have Postgres installed
Since the command is not
I watched while the OS was installed and it looked like postgres was
installed but the Ubuntu package apparently didnt install it all or it
didnt install it correctly.
From: Steve Crawford [mailto:scrawf...@pinpointresearch.com]
Sent: Thursday, November 01, 2012 4:43 PM
To: Boszormenyi
That is the problem. There doesn't seem to be any copy on the Linux shell
that I am running (I think it is bash).
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Chris Angelico
Sent: Thursday, November 01, 2012 9:21 AM
On Fri, Nov 2, 2012 at 8:56 AM, Kevin Burton rkevinbur...@charter.net wrote:
That is the problem. There doesn't seem to be any copy on the Linux shell
that I am running (I think it is bash).
My crystal ball tells me that you're SSHing to your remote server,
running SSH in some kind of local
On 11/01/2012 02:49 PM, Kevin Burton wrote:
I watched while the OS was installed and it looked like postgres was
installed but the Ubuntu package apparently didn't install it all or
it didn't install it correctly.
You may have installed a portion of PostgreSQL - possibly just the
client
On 11/01/2012 02:56 PM, Kevin Burton wrote:
That is the problem. There doesn't seem to be any copy on the Linux shell
that I am running (I think it is bash).
At a guess you are running the commands from the wrong shell. I asked
before whether you are running from different machines and you
On 11/01/2012 03:03 PM, Chris Angelico wrote:
On Fri, Nov 2, 2012 at 8:56 AM, Kevin Burton rkevinbur...@charter.net wrote:
That is the problem. There doesn't seem to be any copy on the Linux shell
that I am running (I think it is bash).
My crystal ball tells me that you're SSHing to your
On Fri, Nov 2, 2012 at 10:35 AM, Adrian Klaver adrian.kla...@gmail.com wrote:
On 11/01/2012 03:03 PM, Chris Angelico wrote:
My crystal ball tells me that you're SSHing to your remote server,
running SSH in some kind of local terminal. It's the local terminal
that will offer copy/paste
Hi
Sorry for my English.
I'm running pgsql8.4 server on debian,the client is the python
library(psycopg2) on the same mechine.
The client connect server via 127.0.0.1:5432.
The psycopg2 connect function *succesed,but throw a exception *
server closed the connection unexpectedly
This probably
Sorry!
I typed the enter key and sent the uncomplete message.
The psycopg2 connect function succesed,but throw a exception
server closed the connection unexpectedly
This probably means the server terminated abnormally before or while
processing the request.
when executing any sql statement.
On 11/01/2012 07:24 PM, Dongkuo Ma wrote:
Hi
Sorry for my English.
I'm running pgsql8.4 server on debian,the client is the python
library(psycopg2) on the same mechine.
The client connect server via 127.0.0.1:5432 http://127.0.0.1:5432.
The psycopg2 connect function /succesed,but throw a
On 11/01/2012 07:32 PM, Dongkuo Ma wrote:
Sorry!
I typed the enter key and sent the uncomplete message.
The psycopg2 connect function succesed,but throw a exception
server closed the connection unexpectedly
This probably means the server terminated abnormally before or while
processing the
On Wed, Oct 31, 2012 at 7:24 AM, Jürgen Fuchsberger
juergen.fuchsber...@uni-graz.at wrote:
Hi all,
I have a problem with a corrupt backup, fortunately I was only testing so I
did not loose any data. Unfortunetely what I did is to follow the backup
guidelines in the documentation, which I
Hi
the python code is
logging.info(database connecting...)
conn = connect(database=dbname, user=user,
password=password,host=127.0.0.1)
logging.info(database connected)
conn.autocommit = True
conn.set_client_encoding('UTF8')
cur = conn.cursor()
#the above code executed without exception
#and
On 11/01/2012 07:57 PM, Dongkuo Ma wrote:
Hi
the python code is
logging.info http://logging.info(database connecting...)
conn = connect(database=dbname, user=user,
password=password,host=127.0.0.1)
logging.info http://logging.info(database connected)
conn.autocommit = True
On Fri, Nov 2, 2012 at 1:57 PM, Dongkuo Ma luc@gmail.com wrote:
Hi
the python code is
logging.info(database connecting...)
conn = connect(database=dbname, user=user,
password=password,host=127.0.0.1)
logging.info(database connected)
conn.autocommit = True
I connect to database and then fork a new process!
Now it's ok.
Thanks.
On Fri, Nov 2, 2012 at 11:17 AM, Adrian Klaver adrian.kla...@gmail.comwrote:
On 11/01/2012 07:57 PM, Dongkuo Ma wrote:
Hi
the python code is
logging.info http://logging.info(**database connecting...)
conn =
On Thu, Nov 1, 2012 at 12:43 PM, Svancara, Randall rsvanc...@wsu.edu wrote:
We are using a third party monitoring solution called Zabbix with Postgresql
9.1.We are observing lots of sharelock problems possibly as a result of
multiple, concurrent updates to the specific table called items.
On Fri, Nov 2, 2012 at 2:43 PM, Dongkuo Ma luc@gmail.com wrote:
I connect to database and then fork a new process!
Now it's ok.
Thanks.
Ah, yes, that would be a dangerous thing to do :)
ChrisA
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
80 matches
Mail list logo