On Fri, 19 Oct 2001, Tom Lane wrote:
> 1. Target database is named by -d switch, else default to dbname
>from dump file.
>
> 2. If --create specified, connect to template1 and issue CREATE DATABASE
>for target.
Should there be an option for what database as template for doing the
create
Allan Engelhardt <[EMAIL PROTECTED]> writes:
> This looks like a bug, or can somebody explain how I'm supposed to
> restore a custom archive dump?
It looks to me like pg_restore is a tad confused, or at least confusing,
about how it handles selection of database. One thing we ought to
figure ou
Sorry, my bad. I thought your whole point was in regards to the sleep command (which I
really didn't understand why). However, your point about stressing the server is a
very valid point, and I did not catch that in your earlier post.
My apologies for the misunderstanding...
--brett
p.s. it's
ALTER TABLE RENAME TO
should do it.
On Fri, 19 Oct 2001, James Kelty wrote:
> I have a table with a column that needs renameing. I do not know how to do
> this, and if anyone could point me in the right direction, I would really
> appreciate it!
---(end of broadcast
On Fri, 19 Oct 2001, James Kelty wrote:
> I have a table with a column that needs renameing. I do not know how to do
> this, and if anyone could point me in the right direction, I would really
> appreciate it!
ALTER TABLE RENAME TO ;
This is documented in the PostgreSQL reference manual:
htt
I have a table with a column that needs renameing. I do not know how to do
this, and if anyone could point me in the right direction, I would really
appreciate it!
Thanks.
-James
--
James Kelty
Sr. Unix Systems Administrator
The Ashland Agency
541.488.0801
[EMAIL PROTECTED]
Fabio Serra wrote:
> Hi all,
> I'm not a Linux Guru and I'm trying to install PG 7.1.3 on Suse 7.2.
> Unfortunately SuSe has not prepared a packet yet and the last Suse
> version is 7.0.3.
> In any case, I have some questions to do a good job.
>
> 1) Is it better to install from source or from
On Thu, Oct 18, 2001 at 01:55:33PM -0400, Tom Lane wrote:
> Andrew Hill <[EMAIL PROTECTED]> writes:
> > Normally, 32 connections is heaps for what I need. However, I often get
> > connections that seem to be doing nothing. For example:
>
> > [bash]
> > \_ postmaster -i -D/var/pgsql/data -N 32
On Fri, 19 Oct 2001, Shuzo Kubo wrote:
> Hi,
>
> I have a web application using PostgreSQL 7.1.3 with a table that
> experiences alot of UPDATEs. I shouldn't be updating the data so much to
> start off with but can no longer avoid the situation.
>
> I would like to vacuum a table (1 table only)
This looks like a bug, or can somebody explain how I'm supposed to
restore a custom archive dump?
$ createdb foo
CREATE DATABASE
$ psql foo
foo=# create table users (id serial);
NOTICE: CREATE TABLE will create implicit sequence 'users_id_seq' for
SERIAL column 'users.id'
NOTICE: CREATE TABLE
Brett,
It appears that I may have upset you somehow. I didn't intend to. I
chose to write the PERL script to place them in a transaction to help
improve performance a little bit on each pass. By building and tearing
down a connection to the postmaster everytime you send an update, you will
b
Hi,
I have a web application using PostgreSQL 7.1.3 with a table that
experiences alot of UPDATEs. I shouldn't be updating the data so much to
start off with but can no longer avoid the situation.
I would like to vacuum a table (1 table only) to maintain an acceptable
performance. Is it safe to v
On Thu, 18 Oct 2001, Tom Lane wrote:
> In its present form it's far too bulky to be kept around over any long
> period of time --- or didn't you notice all the squawks about WAL files
> overrunning disk as soon as anyone had a long-running transaction?
hm.. How does this compare with the Oracle
"Moovarkku Mudhalvan" wrote:
>Hi Friends,
>
>Greetings. What is the default password for the user postgres.. Let me
>change the password.. If i change the password.. Does it make any problem in
>my datas...
There is no password by default; create one with ALTER USER.
Passwords do n
"Joe DeBrunner" <[EMAIL PROTECTED]> writes:
> I checked the pg_shadow table and all of the users I have added are still
> there. Can't tell if the usesysid for each of them has changed or not. Is
> there any way to determine the database owners id as listed in pg_database?
select * from pg_databa
15 matches
Mail list logo
