Hello,
I am create one linux user that "dba" with password "password". I
create one database user "dba_user" with password "dba_user".
I add entry into pg_ident.conf
MAPNAME SYSTEM-USERNAME PG-USERNAME
dba_map dba dba_user
I want to connect dba us
Karuna Karpe wrote:
> I am create one linux user that "dba"
> I create one database user "dba_user"
> I add entry into pg_ident.conf
>
> MAPNAME SYSTEM-USERNAME PG-USERNAME
> dba_map dba dba_user
>
> I want to connect dba user to database edb.
> ./
I am trying to document how to recover a table that has been dropped by using
pg_restore.
This is the table as it was originally:
puppet=# \d hosts
Table "public.hosts"
Column | Type | Modifiers
Hi,
I am new to PostgreSQL. We are using PostgreSQL 9.0.2 on our linux
server. We have an instance of PostgreSQL 9.0 running using the primary
partition on the server.
We want to use the pg_dump and psql programs to migrate the data during
our software upgrade process. For upgrade, we plan t
Krishnamurthy Radhakrishnan wrote:
> pg_dump works before chrooting to the secondary partition. Can
> you please provide a way to dump the data after chrooting?
How about connecting through a TCP connection and piping directly
from pg_dump to psql?
Of course, these days you have the option o
Hi Kevin,
Can you please elaborate how to do the following?
connecting through a TCP connection and piping directly
from pg_dump to psql
Since we could have DB schema changes between the versions, we may not
be able to copy the data directory.
Does pg_upgrade support changes to the schema?
On 10/24/11 3:10 PM, Krishnamurthy Radhakrishnan wrote:
Hi,
I am new to PostgreSQL. We are using PostgreSQL 9.0.2 on our linux server. We
have an instance of PostgreSQL 9.0 running using the primary partition on the
server.
We want to use the pg_dump and psql programs to migrate the data duri
On Tue, Oct 25, 2011 at 3:26 AM, Greg Williamson wrote:
> I am trying to document how to recover a table that has been dropped by
> using pg_restore.
>
> This is the table as it was originally:
> puppet=# \d hosts
> Table "public.hosts"
> Column |
Raghu Ram wrote:
>
>Try with below work-around to restore only hosts table from compressed dump
>file:
>
>
>"pg_restore
>-t hosts -Fc /var/data/pgsql/backups/prodDB/20111017_puppet.pgdump >
>hosts_plaindump" [ i.e you'll get a human-readable dump ]
>
Did you actually try this ?
This does n
Greg Williamson writes:
> What I am I missing ? Or is pg_restore just not capable of restoring the full
> definition of a table ?
There isn't any provision for doing that automatically; it would be a
bit tough to determine exactly what the "full definition" consists of
in a way that makes everyb
Thanks Craig.
After configuring to accept TCP connections on port 5432, I tried to
specify the hostname as shown below and that didn't help. Is there
anything else that needs to be configured?
pg_dump -h bldr-ccm36.cisco.com -p 5432 -a -U postgres
pg_dump: [archiver (db)] connection to databas
On 25/10/11 11:01, Krishnamurthy Radhakrishnan wrote:
> Thanks Craig.
>
> After configuring to accept TCP connections on port 5432, I tried to
> specify the hostname as shown below and that didn't help. Is there
> anything else that needs to be configured?
> pg_dump -h bldr-ccm36.cisco.com -p 5432
12 matches
Mail list logo
